| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
Problem with comma seperated list
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with comma seperated list
Save your file in .csv format from options in Save As.
-----Original 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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with comma seperated list
I have done this and it does not work when the addresses are rows in the
same column. Any other ideas? "Serkan" wrote in message ... Save your file in .csv format from options in Save As. -----Original 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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with comma seperated list
Try Copy/Paste Special/Transpose first so that the data is
in a single row rather than a column. -----Original Message----- I have done this and it does not work when the addresses are rows in the same column. Any other ideas? "Serkan" wrote in message ... Save your file in .csv format from options in Save As. -----Original 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 . . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with comma seperated list
But there are 2000 rows !!
On Mon, 23 Feb 2004 04:24:17 -0800, wrote: Try Copy/Paste Special/Transpose first so that the data is in a single row rather than a column. -----Original Message----- I have done this and it does not work when the addresses are rows in the same column. Any other ideas? "Serkan" wrote in message .. . Save your file in .csv format from options in Save As. -----Original 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 . . Steve |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with comma seperated list
Yes... So what do I do? =)
"Steve Walton" wrote in message ... But there are 2000 rows !! On Mon, 23 Feb 2004 04:24:17 -0800, wrote: Try Copy/Paste Special/Transpose first so that the data is in a single row rather than a column. -----Original Message----- I have done this and it does not work when the addresses are rows in the same column. Any other ideas? "Serkan" wrote in message .. . Save your file in .csv format from options in Save As. -----Original 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 . . Steve |
|
#7
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
|
Problem with comma seperated list
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) "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 |
|
#8
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
|
Problem with comma seperated list
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 |
|
#9
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
|
Problem with comma seperated list
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 |
|
#10
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
|
Problem with comma seperated list
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 |
|
#11
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
|
|||
|
|||
|
Problem with comma seperated list
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List cell values seperated by comma if criteria met | Excel Worksheet Functions | |||
| Comma Seperated File | Excel Worksheet Functions | |||
| comma seperated file import | Excel Discussion (Misc queries) | |||
| How to split a value seperated by comma? | Excel Discussion (Misc queries) | |||
| Importing Comma Seperated Text Please Help ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
