Problem with comma seperated list

  • Thread starter Thread starter Siw H. Thorslund
  • Start date Start date
S

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
 
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)
 
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
 
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? =)
 
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.
 
Back
Top