FORMULA TO REMOVE TEXT FROM A CELL
=IF(ISNUMBER(A1),A1,--LEFT(A1,FIND(" ",A1)-1))
--
David Biddulph
"Faraz A. Qureshi" wrote in
message ...
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
|