extract center char
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 |
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 |
All times are GMT +1. The time now is 05:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com