View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Remove Numeric from a Text String - Help?

ASAP utilities, a free add-in available at www.asap-utilities.com has a
feature that will do it nicely for you..........

Vaya con Dios,
Chuck, CABGx3






"Louise" wrote:

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,