Extract URL's from a text cell

[euanb21]

Hi there,

I'm having trouble figuring out how to extract a URL from a cell in Excel 2010

I have a list of cells, each containing a URL which appears at different positions in each cell. An example is below:

Please Login or Register  to view this content.

I want to extract the URL into a cell opposite the original cell so I would end up with

Please Login or Register  to view this content.

I want to be able to replicate the formula so it finds the URL regardless of the position it sits in the cell.

I think it can be done through some combination of "=mid" and "=search" but I can't get it to work.

Can anyone help me?

Many thanks in advance.

[oeldere]

First copy the value to column B

On the data in column B

Cntr+H
*http
http

CNTRL+H
/*
leave empty

What Tumblr tells us about the future of the media http://t.co/vrescovT /@thewalluk http://t.co/vrescovT


See the attached file.

[euanb21]

Hi oeldere; thanks for the help - I hadn't thought of using find and replace.

I still cant get that to work - the first Find/Replace leaves me with

Please Login or Register  to view this content.

But then using "/*" and leaving the second field empty leaves me with:

Please Login or Register  to view this content.

[oeldere]

Please Login or Register  to view this content.

But then using "/*" and leaving the second field empty leaves me with:

It has to be GAP/*

See my earlier posted example.

" /*"

[icestationzbra]

if you want to solve this using a formula, try the following in B1 (with your input string in A1):

Please Login or Register  to view this content.

this formula assumes that you need to extract the string that starts with HTTP and ends with a white space (" ").

so, with input string - What Tumblr tells us about the future of the media http://t.co/vrescovT /@thewalluk - the output would be - http://t.co/vrescovT.

[euanb21]

oeldere, thanks, that works and is really simple once I realised there was a space in the example.

icestationzbra, thanks as well; I'd really wanted to use a formula and de-construct it to understand how it worked.

Both methods work equally well. Thanks!