Help: How do I remove the space at the end of a number?

[japorms]

Guys,

This come up with me recently. How do I remove the space at the end of
number?

EX: 29.15space

I'm thinking of using the "Replace" from the Edit menu. I just can't
remember how to do it.

Can someone remember how to it?

I can't add the numbers because of the space.

 

[Guest]

Edit > Replace > type a space in the FindWhat: window and leave the
ReplaceWith: window blank > ReplaceAll.......

Vaya con Dios,
Chuck, CABGx3

 

[Bernard Liengme]

I seem to recall that Chip has stuff on this topic
www.cpearson.com
best wishes

 

[Opinicus]

This come up with me recently. How do I remove the space at the end of
number?
EX: 29.15space

If there is exactly one space at the end of the number, this will do it
(assuming the number is in A1):

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

 

[Scoops]

Guys,

This come up with me recently. How do I remove the space at the end of
number?

EX: 29.15space

H japorms

Type 1 in a cell

Copy the cell

Select your "spaced" numbers

Edit > Paste Special > Multiply > OK

Regards

Steve

 

[Bernard Liengme]

Try =VALUE(SUBSTITUTE(A1,CHAR(160),""))

 

[Guest]

Another thing.........I can only get a trailing space to exist if the value
is actually TEXT, so this would work....

=TRIM(A1)

And if you wanted to convert it to a number,

=TRIM(A1)*1

Vaya con Dios,
Chuck, CABGx3