removing commas from numbers etc.

[Guest]

Ok this is hard to explain but here it goes - how do I remove spaces in
between commas for example in one cell I have the following: 1234 , 1234 ,
1234 , I need to remove the space and have the commas after the number
example 123, 123, 123, 123, thanks to anyone who can help me with this issue
i dont' want the spaces in between the commas i want them after...but
unfortunately i have a huge mailer list that i need to fix and don't want to
do one by one thanks

 

[Guest]

Assuming data in A1 down,
try in B1:
=TRIM(SUBSTITUTE(A1," , ",", "))
Copy down

 

[Arvi Laanemets]

Hi

Select the range with entries in question;
Select Replace from Edit menu;
ReplaceAll " ," with ","