View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
oldLearner57 oldLearner57 is offline
external usenet poster
 
Posts: 119
Default 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