extract center char
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
|