View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Louise Louise is offline
external usenet poster
 
Posts: 217
Default Remove Numeric from a Text String - Help?

Hi,

Can anyone helps me with a problem I have got?

I have a column of cells with data in e.g.

123 apple
4390 banana
yellow 56973

I need to remove the numerics and leave the text - how can i do this easily?

Thanks,