Find Jobs
Hire Freelancers

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

$10-30 USD

In Progress
Posted over 5 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 17907344

About the project

16 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average $26 USD for this job
User 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 in 1 day
4.9 (339 reviews)
8.0
8.0
User Avatar
Dear Client I can do this for you. Please provide me the opportunity to do this project for you. Thanks Roy
$50 USD in 1 day
4.9 (412 reviews)
7.1
7.1
User 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 in 1 day
4.9 (376 reviews)
7.2
7.2
User Avatar
Hello. I have good skills in Excel. I'm interest to your project. Contact me please. Thank you. Yang L.
$25 USD in 1 day
4.8 (90 reviews)
5.8
5.8
User 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 in 1 day
5.0 (44 reviews)
5.1
5.1
User 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 in 1 day
4.8 (88 reviews)
5.3
5.3
User 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 in 1 day
4.9 (27 reviews)
4.3
4.3
User 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 in 1 day
5.0 (9 reviews)
3.6
3.6
User 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 in 1 day
4.9 (15 reviews)
3.6
3.6
User 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 in 1 day
4.9 (15 reviews)
3.2
3.2
User 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 in 1 day
5.0 (4 reviews)
1.6
1.6
User 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 in 1 day
5.0 (2 reviews)
1.0
1.0
User 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 in 1 day
0.0 (0 reviews)
0.0
0.0
User 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 in 1 day
0.0 (0 reviews)
0.0
0.0
User 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 in 1 day
0.0 (0 reviews)
0.0
0.0
User 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 in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
Centurion, South Africa
5.0
25
Payment method verified
Member since Mar 18, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.