Converting string to number

's Computer Specifications

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

's Computer Specifications

This works but is still a string, how do I turn this to number?
thanks
(E-Mail Removed) says...
> =LEFT(A1, LEN(A1)-5)
>
> Will return your data as required as long as the text to be stripped is
> constant
>

's Computer Specifications

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 Removed) says...
> 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.
>

's Computer Specifications

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

--

HTH

Bob

"kenppy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> This works but is still a string, how do I turn this to number?
> thanks
> (E-Mail Removed) says...
>> =LEFT(A1, LEN(A1)-5)
>>
>> Will return your data as required as long as the text to be stripped is
>> constant
>>

's Computer Specifications

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

--
Best Regards,

Luke M
"kenppy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> This works but is still a string, how do I turn this to number?
> thanks
> (E-Mail Removed) says...
>> =LEFT(A1, LEN(A1)-5)
>>
>> Will return your data as required as long as the text to be stripped is
>> constant
>>

's Computer Specifications

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

--
Best Regards,

Luke M
"kenppy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 Removed) says...
>> 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.
>>

's Computer Specifications

Thanks all of you, it's working now

> Sorry try
> =LEFT(A1, LEN(A1)-6)
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
converting number string to number with decimal	=?Utf-8?B?cm9ydGl6?=	Microsoft Excel Worksheet Functions	2	15th Sep 2005 08:34 PM
Re: Converting a string to a string that contains the ASCII values of each letter in the origional string	Jay B. Harlow [MVP - Outlook]	Microsoft C# .NET	7	1st Aug 2003 06:03 PM
Re: Converting a string to a string that contains the ASCII values of each letter in the origional string	Mikael Jansson	Microsoft C# .NET	0	31st Jul 2003 08:42 PM
Re: Converting a string to a string that contains the ASCII values of each letter in the origional string	Jon Skeet	Microsoft C# .NET	0	31st Jul 2003 08:38 PM
Re: Converting a string to a string that contains the ASCII values of each letter in the origional string	Frank Oquendo	Microsoft C# .NET	0	31st Jul 2003 08:36 PM