I have an Excel spreadsheet that contains around 1500 html links.
- All the addresses start out in the same manner. i.e. http://www.frogs.com/. What I want to extract into another cell (or workshee) is the part of the links that are different from one another.
Is there a way to automate this process with a macro?
Suppose the hyperlink is in A1 in c1 (or any other cell in row 1)
- Use this formula:
- So, suppose other hyperlinks are in A2, A3... etc and copy formula down.
Thanks to venkat1926
for this tip on the forum.
Published by aakai1056
Latest update on September 26, 2012 at 07:16 AM by deri58.