Hi
i have a column of data in the form of a string
ie 123 i want to convert this to a number
the problem is that the sting has a space at the beginning
How do i remove the space and convert this string to a number

thanks
kevin

Hi,

Easiest way: enter a single 1 in any cell. Copy it (ctrl+c). Select the
range, you want converted. Select edit/paste special. Check values under
paste and multiply under operation. Click OK.

/Sune

"kevcar40" wrote:

Hi
i have a column of data in the form of a string
ie 123 i want to convert this to a number
the problem is that the sting has a space at the beginning
How do i remove the space and convert this string to a number

thanks
kevin

I would say the easiest way would be to use datatext to columns, then click
finish

--
Regards,

Peo Sjoblom



"Sune Fibaek" wrote in message
...
Hi,

Easiest way: enter a single 1 in any cell. Copy it (ctrl+c). Select the
range, you want converted. Select edit/paste special. Check values under
paste and multiply under operation. Click OK.

/Sune

"kevcar40" wrote:

Hi
i have a column of data in the form of a string
ie 123 i want to convert this to a number
the problem is that the sting has a space at the beginning
How do i remove the space and convert this string to a number

thanks
kevin

Yes, one might argue that :)

(Okay, you'r right. But the other method isn't all that difficult either.)

/Sune

"Peo Sjoblom" wrote:

I would say the easiest way would be to use datatext to columns, then click
finish

--
Regards,

Peo Sjoblom



"Sune Fibaek" wrote in message
...
Hi,

Easiest way: enter a single 1 in any cell. Copy it (ctrl+c). Select the
range, you want converted. Select edit/paste special. Check values under
paste and multiply under operation. Click OK.

/Sune

"kevcar40" wrote:

Hi
i have a column of data in the form of a string
ie 123 i want to convert this to a number
the problem is that the sting has a space at the beginning
How do i remove the space and convert this string to a number

thanks
kevin

On 3 Jul, 16:36, Sune Fibaek
wrote:
Yes, one might argue that :)

(Okay, you'r right. But the other method isn't all that difficult either.)

/Sune



"Peo Sjoblom" wrote:
I would say the easiest way would be to use datatext to columns, then click
finish

--
Regards,

Peo Sjoblom

"Sune Fibaek" wrote in message
...
Hi,

Easiest way: enter a single 1 in any cell. Copy it (ctrl+c). Select the
range, you want converted. Select edit/paste special. Check values under
paste and multiply under operation. Click OK.

/Sune

"kevcar40" wrote:

Hi
i have a column of data in the form of a string
ie 123 i want to convert this to a number
the problem is that the sting has a space at the beginning
How do i remove the space and convert this string to a number

thanks
kevin- Hide quoted text -

- Show quoted text -

THanks both
this does not remove the leading blank space

Perhaps it isn't a space (character 32) but rather a non-breaking
space (character 160), especially if you have copied the data from an
HTML source (web-site). You could try this formula in an adjacent
cell:

=RIGHT(A1,LEN(A1)-1)*1

Then copy the formula down for as many values as you have in column A.
You can then fix the values by highlighting all the cells with the
formula in, click <copy then Edit | Paste Special | Values (check) |
OK then <Esc or <Enter. Then you can delete the original column.

Hope this helps.

Pete

On Jul 4, 10:29 am, kevcar40 wrote:
On 3 Jul, 16:36, Sune Fibaek
wrote:





Yes, one might argue that :)

(Okay, you'r right. But the other method isn't all that difficult either.)

/Sune

"Peo Sjoblom" wrote:
I would say the easiest way would be to use datatext to columns, then click
finish

--
Regards,

Peo Sjoblom

"Sune Fibaek" wrote in message
...
Hi,

Easiest way: enter a single 1 in any cell. Copy it (ctrl+c). Select the
range, you want converted. Select edit/paste special. Check values under
paste and multiply under operation. Click OK.

/Sune

"kevcar40" wrote:

Hi
i have a column of data in the form of a string
ie 123 i want to convert this to a number
the problem is that the sting has a space at the beginning
How do i remove the space and convert this string to a number

thanks
kevin- Hide quoted text -

- Show quoted text -

THanks both
this does not remove the leading blank space- Hide quoted text -

- Show quoted text -

On 4 Jul, 11:43, Pete_UK wrote:
Perhaps it isn't a space (character 32) but rather a non-breaking
space (character 160), especially if you have copied the data from an
HTML source (web-site). You could try this formula in an adjacent
cell:

=RIGHT(A1,LEN(A1)-1)*1

Then copy the formula down for as many values as you have in column A.
You can then fix the values by highlighting all the cells with the
formula in, click <copy then Edit | Paste Special | Values (check) |
OK then <Esc or <Enter. Then you can delete the original column.

Hope this helps.

Pete

On Jul 4, 10:29 am, kevcar40 wrote:



On 3 Jul, 16:36, Sune Fibaek
wrote:

Yes, one might argue that :)

(Okay, you'r right. But the other method isn't all that difficult either.)

/Sune

"Peo Sjoblom" wrote:
I would say the easiest way would be to use datatext to columns, then click
finish

--
Regards,

Peo Sjoblom

"Sune Fibaek" wrote in message
...
Hi,

Easiest way: enter a single 1 in any cell. Copy it (ctrl+c). Select the
range, you want converted. Select edit/paste special. Check values under
paste and multiply under operation. Click OK.

/Sune

"kevcar40" wrote:

Hi
i have a column of data in the form of a string
ie 123 i want to convert this to a number
the problem is that the sting has a space at the beginning
How do i remove the space and convert this string to a number

thanks
kevin- Hide quoted text -

- Show quoted text -

THanks both
this does not remove the leading blank space- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -
Worked a treat

thank you

You're welcome - thanks for feeding back.

Pete

On Jul 4, 11:49 am, kevcar40 wrote:
On 4 Jul, 11:43, Pete_UK wrote:



Perhaps it isn't a space (character 32) but rather a non-breaking
space (character 160), especially if you have copied the data from an
HTML source (web-site). You could try this formula in an adjacent
cell:

=RIGHT(A1,LEN(A1)-1)*1

Then copy the formula down for as many values as you have in column A.
You can then fix the values by highlighting all the cells with the
formula in, click <copy then Edit | Paste Special | Values (check) |
OK then <Esc or <Enter. Then you can delete the original column.

Hope this helps.

Pete

On Jul 4, 10:29 am, kevcar40 wrote:

On 3 Jul, 16:36, Sune Fibaek
wrote:

Yes, one might argue that :)

(Okay, you'r right. But the other method isn't all that difficult either.)

/Sune

"Peo Sjoblom" wrote:
I would say the easiest way would be to use datatext to columns, then click
finish

--
Regards,

Peo Sjoblom

"Sune Fibaek" wrote in message
...
Hi,

Easiest way: enter a single 1 in any cell. Copy it (ctrl+c). Select the
range, you want converted. Select edit/paste special. Check values under
paste and multiply under operation. Click OK.

/Sune

"kevcar40" wrote:

Hi
i have a column of data in the form of a string
ie 123 i want to convert this to a number
the problem is that the sting has a space at the beginning
How do i remove the space and convert this string to a number

thanks
kevin- Hide quoted text -

- Show quoted text -

THanks both
this does not remove the leading blank space- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Worked a treat

thank you- Hide quoted text -

- Show quoted text -