Find Jobs
Hire Freelancers

Excel formula or Macro to extract text between anchor tags and be hyperlinked

$10-30 USD

Käynnissä
Julkaistu yli 5 vuotta sitten

$10-30 USD

Maksettu toimituksen yhteydessä
I need a formula or macro to extract URL’s and text between <a href> and </a> tags. There could be up to 20 occurrences per cell. All links merged into one column, and all the text between the anchor text in 1 column. I do have a formula in sheet 1, cell D, but its not correct. I need it to be extended to cater for 20 occurrences per cell, as well as only get the link and the text directly after the > tag of the link. I copied the links and sorted into Sheet 2.
Projektin tunnus (ID): 17907344

Tietoa projektista

16 ehdotukset
Etäprojekti
Aktiivinen 5 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
16 freelancers are bidding on average $26 USD for this job
Käyttäjän avatar
This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel formula or Macro. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.I have more than 5 year of experience in Excel. Please ping me for more discussion.
$50 USD 1 päivässä
4,9 (339 arvostelua)
8,0
8,0
Käyttäjän avatar
Dear Client I can do this for you. Please provide me the opportunity to do this project for you. Thanks Roy
$50 USD 1 päivässä
4,9 (412 arvostelua)
7,1
7,1
Käyttäjän avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do make formula to grab data between spesific tag like u need. please give me this job and im able to start working today Thank You Sincerely Galih AP
$30 USD 1 päivässä
4,9 (376 arvostelua)
7,2
7,2
Käyttäjän avatar
Hello. I have good skills in Excel. I'm interest to your project. Contact me please. Thank you. Yang L.
$25 USD 1 päivässä
4,8 (90 arvostelua)
5,8
5,8
Käyttäjän avatar
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
$30 USD 1 päivässä
5,0 (44 arvostelua)
5,1
5,1
Käyttäjän avatar
I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start
$25 USD 1 päivässä
4,8 (88 arvostelua)
5,3
5,3
Käyttäjän avatar
Honorable concerned, I was reading the description of your recent project and I thought that I am the one who can fulfill your requirements within required timespan. I have recently done a project that was similar to your project. Hope to hear from you soon. Regards, Muhammad Haseeb
$25 USD 1 päivässä
4,9 (27 arvostelua)
4,3
4,3
Käyttäjän avatar
Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using excel macro. A brief summary of my profile as following. Over 12 years of experience in IT field of software development and support. On technical front I have good experience on following technologies. Databases : SQL Server, Universe/Unidata, Oracle,MS Access. Development Technologies: C#,Winform, WPF, ASP.Net MVC, Pick Basic/UniBasic, Visual Basic 6, Excel VBA. Reporting/Designer Tool: SSRS, Crystal Reports, System Builder(SB+). I would very much enjoy having the opportunity to talk with you further to discuss the requirements and expectations regarding the project, and how I could use my skills to benefit you. Thank you for considering my application. I look forward to hearing from you. Regards, Naveen Upadhyay
$25 USD 1 päivässä
5,0 (9 arvostelua)
3,6
3,6
Käyttäjän avatar
thanks for your detailed instructions.l can do it now. i will provide you vba macro script which will be able to handle any number of rows and emails with one click.
$15 USD 1 päivässä
4,9 (15 arvostelua)
3,6
3,6
Käyttäjän avatar
I have 12+ yrs Experience in Software, Excel macro & Office Automation. Currently working as Full time Freelancer. and doing projects in Excel Macro, VBA, MS Word, Outlook, Office Automation & Web Scraping. Please visit my tech blog officetricks to know more about my expertise. Services Provided - VBA: 1. Excel Macro (VBA) 2. Excel Pivot Charts & Tables 3. Excel Auto Filter, Vlookup, Formula Assistance 4. Excel to Access 5. User Forms in Excel 6. Calendars in Excel 7. Bulk Files Processing in side a Folder 8. Folder Operations 9. Sending Email from Excel
$20 USD 1 päivässä
4,9 (15 arvostelua)
3,2
3,2
Käyttäjän avatar
Hello, You need a macro to accomplish that task. I'll do a macro for you that combines the links for each row into one cell, links will be separated by semi colon or any separator of your choice. Let me know if your interested. All can be finished in one day.
$30 USD 1 päivässä
5,0 (4 arvostelua)
1,6
1,6
Käyttäjän avatar
Hi, there are no URLs in sheet2. Please explain in detail. ------------------------------------------- I am a lazy person so I started automating my work and became an expert in it. I have handled huge data and processed them with my automation skills. I have 9 years of experience in the Excel sheets and macro. Handled huge data in office. Completed many automation projects.
$15 USD 1 päivässä
5,0 (2 arvostelua)
1,0
1,0
Käyttäjän avatar
Hey there, I see you are looking for someone who can short your long sheet within minimum time. I'll do it not only in minimum cost but also within minimum time.I'am able to write 45WPM with almost negligible error rate it help to reduce time frame. I have been working on Microsoft excel for the past 7 years i have a well practiced hand on it.I used to work in UBER where i need to work on excel. You just need to tell me the complete details of the project and rest depends on me. Thanks
$10 USD 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Hi there, It's a great opportunity for me to help you in designing excel formula to extract required URLs and text for your business. I am available and accessible 24/7 for you to discuss about it more at your pace over the chat. Please get in touch for further details regarding the required task. I am passionate about creating and designing formulas in EXCEL 2016 which can be helpful for this required task. ★ What You Will Have ★ ✔ Source Files (Excel 2016 and PDF) ✔ Professional 100% Customer Support 24/7 ✔ Guaranteed High Quality work I would love to hear from you positively. kind regards, Zeeshan A.
$30 USD 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Hello sir, I am interested in this job. I have five years of experience ... please ..... explain to me completely ...... and attach a file for demonstration ....
$15 USD 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Boss give me a project because am master of excel Relevant Skills and Experience I have done one year work in office...
$25 USD 1 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan SOUTH AFRICA lippu
Centurion, South Africa
5,0
25
Maksutapa vahvistettu
Liittynyt maalisk. 18, 2008

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.