Converting string to number

  • Thread starter Thread starter kenppy
  • Start date Start date
K

kenppy

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
 
This works but is still a string, how do I turn this to number?
thanks
(e-mail address removed) says...
 
The data is already loading into columns but the length of the stuff to
strip may not be predicted, how would this be treated?
thanks

(e-mail address removed) says...
 
=--LEFT(A1, LEN(A1)-5)


--

HTH

Bob

kenppy said:
This works but is still a string, how do I turn this to number?
thanks
(e-mail address removed) says...
 
Back
Top