View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excel ??[_2_] Excel ??[_2_] is offline
external usenet poster
 
Posts: 19
Default 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