Hi All

On a worksheet
Cell A2 = 4100,
Cell B2 = WM0001
CellD2 when using Text to Columns = 4100, WM0001
how do I get rid of the space so that Cell D2 = 4100,WM0001
I Email over 400 rows of similar information and Cell D2 must not have any
spaces.
I can do it manually but with over 400 rows its a pain - could a macro or
perhaps a VBA function do it automatically.

Any help appreciated

Cheers

Mully