Extract numbers out of text cell entries

[kno24ie]

I have many text cell entries such as these samples:

AB1234C, D5678FC, EGH9012W, etc.

I just need to extract the numbers out of the middle of the entries. The numbers do not always start in the same position but are together.

Thank you in advance for the help!
Jerry

 

[tactps]

If there are always 4 digits:
=MID(A1,SEARCH({1,2,3,4,5,6,7,8,9,0},A1),4)
will work.

 

[barry houdini]

If there are a variable number of digits you could use this array formula

=LOOKUP(9.99999999999999E+307,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&"0123456789")),ROW($1:$255)))

confirmed with CTRL+SHIFT+ENTER

If there are always four digits

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

 

[kno24ie]

Thank you very much!! Those formulas work great!

Jerry