View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
kenppy kenppy is offline
external usenet poster
 
Posts: 4
Default Converting string to number

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