0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Retrieve data selectively from cells



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.
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
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).

0 Comments