Excel - Retrieve data selectively from cells

December 2016



Issue



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?

Solution


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.

Related :

This document entitled « Excel - Retrieve data selectively from cells » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.