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 Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Published by . Latest update on 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/).

0 Comments