Separating by Commas

[Geddy]

I have a list of 100 email adresses who I am inviting to a
non-profit event here in Boston.

They are all in one column (one email address per row).

I need separated by a comma then a space.

Is there a way in excel (excel is preferrable) to export
using comma as a separator?

Thanks!!!
Geddy

 

[Jay]

I have a list of 100 email addresses who I am inviting to a
non-profit event here in Boston.

They are all in one column (one email address per row).

I need separated by a comma then a space.

Here's one way.

First get the addresses in a row, as follows:
- select the addresses.
- go to a new blank worksheet and use
Edit >> Paste special >> Transpose

Then save the resulting worksheet as a CSV file.

To get the "space" after each comma, open the CSV file in Word and use
Edit >> Replace >> Replace all

Be aware that lots of ISPs might consider a message with so many addresses
as spam.