Excel - Retrieve data selectively from cells

April 2018


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. Latest update on September 26, 2012 at 07:16 AM by deri58.
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 (https://ccm.net/).
Excel - Clear the contents of specific cells
Excel - Send value of cell to target