TRIM

[Nikki]

Cell E1 has the name John followed by 13 spaces (comes out of the database
this way). How do I remove the 13 spaces? I tried trim((e1)&" "&g1) but it
doesn't work. Please help as this is driving me crazy. Thanks to those of you
who made suggestions already. I also tried the code in a simple Macro that is
application.trim(range("e1")) and can't seem to get that to work either.

Thanks
Nikki

 

[Kassie]

With your name in E1, insert a new column F.
Enter in F1 =TRIM(E1).
Select F1, copy, and paste special as value in E1. Your spaces should be
gone. Delete Col F

--
HTH

Kassie

Replace xxx with hotmail

 

[JoeU2004]

Cell E1 has the name John followed by 13 spaces [....].
How do I remove the 13 spaces? I tried trim((e1)&" "&g1)
but it doesn't work.

If you enter the formula __exactly__ the way Don told you to yesterday, you
should have no problem. Copy-and-paste the following formula:

=trim(e1)&" "&g1


----- original message -----

 

[Gord Dibben]

See my reply at your other thread.

Please stay with one thread.


Gord Dibben MS Excel MVP