Separating by Commas

  • Thread starter Thread starter Geddy
  • Start date Start date
G

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
 
Geddy said:
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.
Click to expand...

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.
 
Back
Top