MS-Excel truncating non-numeric data from a field 1

[mooneye]

Is there any quick way of deleting non-numeric data from fields, e.g. I want 12.5 to appear instead of 12.5 Kg.

Any help would be greatly appreciated.

 

[DaleWatson123321]

Hi Mooneye,

If your data is in column A, use the following formula in column B, and copy down for all the rows:

=VALUE(LEFT(A1,FIND(" ",A1)-1))

Then of course convert to values, and copy to column A.

Hope this works for you. Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[onedtent]

u can also use edit, replace to replace " kg" with nothing (without quotation marks)

 

[mooneye]

Thanks Dale it did the trick.