How to extract specific numbers after and before certain characters.

[addytiger]

Hi,

I am stuck in between a project.

Please let me know how can I do a certain task of extracting a specific number out of an un symmetrical line.

I would like to have the formula so that i can put it in the excel and all the lines get converted.

For example:

1> -94xms-h1go43n5-3y/vgh/2701377/?hs=false&tok=0fs2fg1X-2CBc1

2> nalvkb-h4ixm13e-2b/vgh/2654658/eml-anet_wlcm-h-visit/?hs=false&tok=1sk3UdVACjj5k1

3> awir40-h34fat8l-29/vgh/1866120/?hs=false&tok=1J02pDDku-xlg1

here are 3 examples of these lines.

what i want to extract is the numbers between vgh/*******/ so the outsome should be: 2701377 , 2654658 , 1866120

I will be grateful for any help!

regards,
Addy

[Adys747]

How many lines do you need help with ?

[tigeravatar]

Addy,

This exact problem has already been solved. See this thread, specifically post #7
http://www.excelforum.com/excel-gene...ric-cells.html

[addytiger]

tiger this is Genius!