Extracting ID's from middle of record.HELP

[DShack]

Hello Everyone,
I'm trying to create a formula that extracts the employee id number out from the below record. The id is in bold. I have tried using left, mid function but have been unsuccessfull in doing so. any help would be greatly apprepriated.

Moussaoui, Abdelmjid 00224827 Fri,Aug 22 8.500 8.50 8.50 $73.78

Thanks

 

[bschwartz]

bschwartz,

Nicely done - one for my archives - thanks.

Thanks Hiker!

 

[hiker95]

bschwartz,

Thanks for the feedback.

I prefer to code, but, my archives are full of formulae like you have produced - thank you

 

[mfexcel]

It may not work if the ID not starts with 0

If the ID is always a 8-digit number, try:
=MID(A1,MIN(IFERROR(FIND(" "&{0,1,2,3,4,5,6,7,8,9},A1),999))+1,8)
CTRL SHIFT ENTER

If the ID may has different number of digits, then try:
=MID(A1,MIN(IFERROR(FIND(" "&{0,1,2,3,4,5,6,7,8,9},A1),999))+1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9}&" ",A1),999))-MIN(IFERROR(FIND(" "&{0,1,2,3,4,5,6,7,8,9},A1),999))+1)
CTRL SHIFT ENTER

This works with all of the examples you posted:

Worksheet Formulas Cell Formula B1 =LEFT(REPLACE(A1,1,FIND(0,A1)-1,""),FIND(" ",REPLACE(A1,1,FIND("0",A1)-1,""))-1) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[István Hirsch]

If the ID always has 8 digits, 3 functions seems enough:

=MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),8)