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.