Problem with comma seperated list

[Siw H. Thorslund]

I have a excel sheet with a column of 2000 e-mail addresses.
How can I export this to a comma separated list?

Thanks... =)

Siw

 

[Bob Phillips]

Save it as a csv file, which is an option in the Save dialog box.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bill Ridgeway]

Click on <Save as>
In <Save as type> scroll down until you get to <CSV OS2 or MS-DOS (*.CSV)
Click on <Save>

Regards.

Bill Ridgeway
Computer Solutions

 

[Siw H. Thorslund]

I know about that solution. Done that...

But it does not save it with commas when all the data is in a column, not in
rows....

Any idea to solve this? =)

 

[Dave Peterson]

You want 2000 email addresses on one line? Each separated by a comma?

If yes, then you could use a helper column:
Put =A1 in cell B1
Put =B1&","&A2 in cell B2

Drag down. It'll build a Christmas tree look. Each cell getting wider than the
one above it.

Now copy that last cell and paste into notepad (or your favorite text editor)
and save it from there.

 

[Siw H. Thorslund]

Thank you for that answer.
You just saved me for a LOT of work.. =)