=LEFT(A1, LEN(A1)-5)

Will return your data as required as long as the text to be stripped is
constant
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"kenppy" wrote:

hi,

I have a set of data that is to be cut and pasted from an external
source.
A typical cell reads '32813.58 sq mm', without the speech marks.
The cell could be formatted before the pasting; but how do I strip off
the units to leave the number only? The number could be any size.

thanks
.