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.
This document, titled « Excel - Retrieve data selectively from cells », is available under the Creative Commons
license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM