Converting string to number

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
 
K

kenppy

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

kenppy

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...
 
B

Bob Phillips

=--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...
Click to expand...
 
L

Luke M

Under Data - Text to Columns, choose delimited. Then choose space as your
delimiter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for detect palindromes and repeats in letters/numbers string 5
Convert Text To Number 3
Number stored as text 4
data spans multiple rows within each cell is collapsed when FILTER is used 0
Convert a range of numbers to strings 2
Macros to convert Data into date format and then plot in graph 7
Pasting a Table from Excel to PP: please help! 1
Custom format string from cell value 2

Top