Extracting characters from a URL

[naga]

Hello everyone,

I have an URL in which I'd like to extract only a few part of it.
Example:

Please Login or Register  to view this content.

I need to omit few characters in the URL.
The output has to be

Please Login or Register  to view this content.

Someone please help me.
Thanks in advance.

[Richard Buttrey]

You've not given us a lot to work with, in particular what determines how much of the string you want. I'm assuming you want everything up to the "ref". In which case

Please Login or Register  to view this content.

[shg]

Or everything up to the last slash ...

[shg]

	A
1	http://amazon.com/gp/product/B000BNCA4K/ref=as_li_tl?tag=pollylolitop-20
2	http://amazon.com/gp/product/B000BNCA4K/
3	A2: =LEFT(A1, FIND("|", SUBSTITUTE(A1, "/", "|", LEN(A1) - LEN(SUBSTITUTE(A1, "/", "")))))

[AlKey]

Or this

Please Login or Register  to view this content.

	A	B
1	http://amazon.com/gp/product/B000BNCA4K/ref=as_li_tl?tag=pollylolitop-20	http://amazon.com/gp/product/B000BNCA4K/

Sheet: Sheet3