Extracting Three Numbers Within String

Hello,

I am on a quest to have 3 numbers pulled from a string (example criteria attached). For instance:

Example String: Egsc, 345, kel, X - CO, P3 - XXB, 546 XXG, 354 BSE

The result I am looking for is 345. The issue is that the three numbers are not always in the same place, but are always between two commas and the number is always formatted comma, space, number.

I have attempted many solves for this, including enlisting ChatGPT, however, to no resolve. Any assistance would be appreciated.

Thank you.

Are you still using XL 2013 ? If not please amend your profile accordingly. Newer versions have other functions. Thx

What version of Excel are you using?

Originally Posted by CheeseSandwich

What version of Excel are you using?

Already asked post #2...

If you are updated to Excel 365 you can try

Formula:

Please Login or Register  to view this content.

and copy down

Just for fun, if you have upgraded to a more recent version, like 365, one way:

Formula:

Please Login or Register  to view this content.

We are using Excel 2013.

Shame, you don't know what you're missing

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Hi to everyone!

Another option could be:

PHP Code: 

=AGGREGATE(15,6,--MID(SUBSTITUTE(","&A2,",",REPT(" ",199)),199*ROW($1:$9),199),1) 


Blessings!