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 :)


--
oldLearner57

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&"0 123456789")),ROW($1:$10000))))

and copy down to see:

neXgen1234bcd 1234
qpIT23456xx 23456
kns001yTdy 1

--
Gary''s Student - gsnu200755


"oldLearner57" wrote:

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 :)


--
oldLearner57