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

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.

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

Vaya con Dios,
Chuck, CABGx3





"japorms" wrote:

>
> 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.
>
>
> --
> japorms
> ------------------------------------------------------------------------
> japorms's Profile: http://www.excelforum.com/member.php...fo&userid=6544
> View this thread: http://www.excelforum.com/showthread...hreadid=557002
>
>

I seem to recall that Chip has stuff on this topic
www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"japorms" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> japorms
> ------------------------------------------------------------------------
> japorms's Profile:
> http://www.excelforum.com/member.php...fo&userid=6544
> View this thread: http://www.excelforum.com/showthread...hreadid=557002
>

"japorms" <[email protected]> wrote

> 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)

--
Bob
http://www.kanyak.com

japorms wrote:
> 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

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"japorms" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> japorms
> ------------------------------------------------------------------------
> japorms's Profile:
> http://www.excelforum.com/member.php...fo&userid=6544
> View this thread: http://www.excelforum.com/showthread...hreadid=557002
>

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



"japorms" wrote:

>
> 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.
>
>
> --
> japorms
> ------------------------------------------------------------------------
> japorms's Profile: http://www.excelforum.com/member.php...fo&userid=6544
> View this thread: http://www.excelforum.com/showthread...hreadid=557002
>
>