Take out a set of numbers from alphanumeric cells

Hi.

I have about 200 cells with 2 different format in text and numbers but they all have a number in between right after /vgh/.

Is there a formula I can use that will return only thee set of numbers removing the text before and after it.

Below are the 2 different examples.

Example 1 : h4ffkwd1-5o/vgh/2447044/eml-anet_wlcm-h-visit/?hs=false&tok=3GMdjcBsfbfBk1
Example 2 : h38ahlur-19/vgh/163311/?hs=false&tok=1CIRLlqwLSB5g1

I have these sort of text and just need the middle set of numbers.

Thanks

Adys747,

Something like this should work for you:

Please Login or Register  to view this content.

Works just fine for me on both your examples... see attached

You're very welcome

If that cares care of your need, please mark this thread as solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Recieved PM from Adys747:

Originally Posted by Adys747

Hi Tiger,

Can you please also help me with these :

Please Login or Register  to view this content.

Thanks,
Ady

Here's the ugly part:
Your post does not comply with Rule 4 of our Forum RULES. Don't Private Message, Visitor message or email questions to moderators or other members. All questions and answers will benefit other posters like yourself. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.


Now that that is out of the way, here's an updated formula that will work for all four examples:

Please Login or Register  to view this content.

Version 2 of example workbook is attached.