Another alternative if you are pasting text into Excel is to use the text to
columns facility.

You'll find this under data - text to columns. Ask again if you need more
help on this.
--
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
.