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


"Dave Peterson" wrote in message
...
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" wrote:

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? =)

"Bill Ridgeway" wrote in message
news:JFr_b.273$lj3.260@newsfe1-win...
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" wrote in message
...
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





--

Dave Peterson