Excel - Retrieve data selectively from cells

March 2017


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.

For example:
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:
  • =RIGHT(A1,LEN(A1)-21)
  • So, suppose other hyperlinks are in A2, A3... etc and copy formula down.

Note that

Thanks to venkat1926 for this tip on the forum.


Published by aakai1056.
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 (ccm.net).