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

Question

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

Report

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

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://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?

Possible to extract partial data in Excel?
Extract data from excel - Forum - Excel
Vba code to search data in excel - How-To - Excel
How to export data from excel to excel - How-To - Excel
How to transfer data in excel from one sheet to another - How-To - Excel
How to update data in excel using vba - How-To - Programming

1 reply

Ask a question

venkat1926 · Accepted Answer · 2009-06-19T19:49:13-0400

Answer 1 / 1

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

797
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
=RIGHT(A1,LEN(A1)-21)
suppose other hyperlinks are in A2 A3 etc copy C1 down

Report

DarkDMize
Jun 20, 2009 at 11:42 AM

Thanks! =)

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

1 reply

Your reply

Subscribe To Our Newsletter!