extract center char

[oldLearner57]

hi community

i have these following data and wish to extract only the number(text format):

example:

A B C
1 neXgen1234bcd

2 qpIT23456xx

3 kns001yTdy

what I wish to have is to extract out the number(text format) char only.

can community kindly assist me on how can I extract such data??


thanks for the help

 

[Gary''s Student]

With your data in A1,A2,A3. In B1 enter:
=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000))))

and copy down to see:

neXgen1234bcd 1234
qpIT23456xx 23456
kns001yTdy 1