Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I export data from Excel as a series of comma-separated val
I am using Excel 2000. I entered my data in a spreadsheet, and saved it as a
CSV file. Now I need to change it to comma-separated values and send it in an e-mail. Here's an example of what I am doing. Swamp Thing 1972 1 FN 1 None None 24.5 Now I need that to be separated by commas instead of cells. Also, it took out my dollar signs and zeros, and I want them back. What do I do? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I export data from Excel as a series of comma-separated val
I use Excel 2003
File|Save As , select file type as CSV file. Then open *.csv with text editor not Excel. You example data will look as below: Swamp Thing, 1972, 1, FN, 1, None , None , 24.5 Tom www.knowlesys.com Web Data Extraction Expert |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I export data from Excel as a series of comma-separated
Thank you Tom, that worked great!
"Tom" wrote: I use Excel 2003 File|Save As , select file type as CSV file. Then open *.csv with text editor not Excel. You example data will look as below: Swamp Thing, 1972, 1, FN, 1, None , None , 24.5 Tom www.knowlesys.com Web Data Extraction Expert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fan charts | Charts and Charting in Excel | |||
Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
export data to Excel?? | Excel Discussion (Misc queries) | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
How can I export Excel data to Quicken? | Excel Discussion (Misc queries) |