removing commas from numbers etc.
 

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
--
2

removing commas from numbers etc.
 

Assuming data in A1 down,
try in B1:
=TRIM(SUBSTITUTE(A1," , ",", "))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Excel ??" wrote:
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
--
2

removing commas from numbers etc.
 

Hi

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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Excel ??" wrote in message
...
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
--
2