Extracting information from strings.

[Hendy]

I am trying to extract a SKU number from a long list of URL's that I
have in a excel spreadsheet.

http://www.randompage.com/images/products/prodDetails/1716673993_lg.jpg

I am trying to extract the number from the URL and parse it out
separately in a different column.

Any help would be great.

Thanks,

Hendy

 

[Peo Sjoblom]

Sorry all I get when clicking your link is the random page, no jpg picture
of your spreadsheet
Maybe you can post how the URLs might look

 

[Ron de Bruin]

Hi Hendy

You can use Data Text to columns in the menubar

Use the first time as delimiter /
Then Select the column with the numbers and use
Data text to column again and use as delimiter _

 

[Hendy]

Ron,

Thank you very much for the tip. It worked exactly as I needed it too.

YAH!

Kind Regards,

Hend