Extracting title from a URL

[naga]

Hi friends,

I am an Ebay seller and I have a list of product URL's I have listed.
Everytime I'm copying and pasting the titles in a cell. This consumes a lot of time.

Example URL:
http://www.ebay.com/itm/Oster-Cordle...e=STRK:MESE:IT

I need a help to solve this issue by a formula which automatically gets the product name from the URL.
The title starts at the 25th character. I tried using mid formula but the length of the titles are not same so sometimes I get other part of the URL in the titles.
Can someone please help me to get the value between "/" and "/".
From the above URL the title for the product is Oster-Cordless-Electric-Corkscrew-Wine-Bottle-Opener-

Thanks in advance.

[FDibbins]

The url example you provided is cut off by the server. Can you paste the whole thing again?

[naga]

[Tony Valko]

This works on the posted example...

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"/",
REPT(" ",255),5),"/",REPT(" ",255),4),255,255))

[naga]

Hello Tony,

Thank you for your valuable time in helping me with this.
This solution works perfectly.
Is it possible to replace the "-" with " " in the Title?

[Tony Valko]

Like this...

=TRIM(SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE(A1,"/",REPT(" ",
255),5),"/",REPT(" ",255),4),255,255),"-"," "))

[AlKey]

Here is with removed dashes

Please Login or Register  to view this content.

[naga]

Thank you Tony and AlKey for your help.
It worked perfectly.

[Tony Valko]

You're welcome. Thanks for the feedback!