How do I export data from Excel as a series of comma-separated val

G

Guest

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?
 
T

Tom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top