Possible to extract partial data in Excel?

DarkDMize - Jun 19, 2009 at 04:39 PM
 DarkDMize - Jun 20, 2009 at 11:42 AM

I have an Excel spreadsheet that contains around 1500 html links.

All the addresses start out common... i.e. http://www.frogs.com/. What I want to extract into another cell (or worksheet) is the uncommon part of the links. For example, https://efty.com/d/404/bull_frogs
or https://efty.com/d/404/tree_frogs.

Is there a way to automate this with a macro or something, or am I stuck doing each and every one manually?

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 19, 2009 at 07:49 PM
suppose the hyperlink is in A1 in c1 (or any other cell in row 1) type this formula
suppose other hyperlinks are in A2 A3 etc copy C1 down
Thanks! =)