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.
Được trao cho:
Hi, I will extract the links between <a> anchor tags with the help of macro and can deliver the completed excel in a few hours. I can start right now. Thanks.
17 freelancer đang chào giá trung bình $26 cho công việc này
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
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
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.
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.
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 ....