Just use Edit - Search/Replace and replace any space with nothing.



"Mythikal" schreef
in bericht ...

I'm looking for a Macro that can remove all unwanted space in the cell?

Eg. +lExample ( Space ) l+

That is the cell and the space after "Example" is there and it has
been done on about 50% of them and i just need a macro or some help so
i can remove all the space without having to go do every single on
considering there is about 2877 of the cells and it could take time if
i had to.

Thankyou.

Alex.


--
Mythikal
------------------------------------------------------------------------
Mythikal's Profile:
http://www.excelforum.com/member.php...o&userid=36680
View this thread: http://www.excelforum.com/showthread...hreadid=564166