View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 594
Default How do I add commas after each text in each cell?

In an adjacent helper column (column B), put this in B1 and copy
down........

=A1&","

Then do Copy PasteSpecial Values on that column to get rid of the
formulas......

Vaya con Dios,
Chuck, CABGx3


"ChrishBiz" wrote in message
...
I have a list of about 23,000 emails. I need to make an E-mail blast. The
only way I know how to do that is by adding a comma at the end of each

one.
How can I save the hassle of inserting a comma manually into each cell?