Removing Spaces from Text

[Satyajit Bhagwat]

Hi Dave,

That was the first thing I did! However, it doesn't seem to work when the
first character is a space (and maybe if all the other characters following
the space are numbers).

I did quite a bit of experimentation with find and replace. But somehow it
didn't work. I'm using Excel 2000. Maybe with the later versions, this has
been rectified.

Thanks anyway for the trouble you took to reply.

Regards,
Satyajit Bhagwat

 

[Frank Kabel]

Hi
try
=TRIM(A1)

or
=SUBSTITUTE(A1," ",""9

 

[Dave Peterson]

It removed true spaces for me. But if you copied from the web, maybe they were
those HTML non-breaking spaces (char(160)).

If Andy's first formula didn't work (and you used his second formula), that's
what I'd suspect.

If you ever get lots more to clean up, you may want to use a macro.

David McRitchie has one at:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")