I am sorry what I sought was to have all the text be removed. Like:

1234Text
12Text34
Text1234

be converted to:

1234
1234
1234

--
Best Regards,

Faraz


"David Biddulph" wrote:

=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