Remove text from a cell

[Tracey]

Hi there

I have some data in a spreadsheet which is an output from another program.
One column has a series of numbers in it, each with the suffix of "kb" and I
want to remove the kb from each cell so that I can sort by number. Is there
an easy way to do this without having to edit each cell individually (I have
about 600 rows!)

thanks
Trace

 

[Frank Kabel]

Hi
one way: Use 'Edit - Replace'

the other way: use the formula
=--TRIM(SUBSTITUTE(A1,"kb",""))
in a helper column

 

[Tracey]

Thanks for your help, the TRIM formula works a treat!