Excel - Retrieve data selectively from cells

March 2017



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


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).