Thread: FORMULA TO REMOVE TEXT FROM A CELL
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Faraz A. Qureshi Faraz A. Qureshi is offline
external usenet poster
  
Posts: 211
Default FORMULA TO REMOVE TEXT FROM A CELL
I have some entries like:

10 Kg
15 Kilo
12
13.5 Kilogram

How, to have all the text be removed from the same having the numericals
remained presented as:

10
15
12
13.5

--
Best Regards,

Faraz
Reply With QuoteReply With Quote