Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Possible to extract partial data in Excel? [Solved/Closed]

Report
-
 DarkDMize -
Hello,

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://eftymarket.com/frogs.com/bull_frogs
or https://eftymarket.com/frogs.com/tree_frogs.

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

1 reply

Answer 1 / 1
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 791
suppose the hyperlink is in A1 in c1 (or any other cell in row 1) type this formula
=RIGHT(A1,LEN(A1)-21)
suppose other hyperlinks are in A2 A3 etc copy C1 down
Thank you
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Report

Thanks! =)
Ask a question