How to convert Excel to ASCII file?

C

CJN

I have a large Excel file with many columns and rows. I need to
convert it to an ASCII file that has each file separated by commas and
with each field surrounded by double quotation marks.

Can anyone guide me as to how to do this?

Many thanks,
 
E

Earl Kiosterud

CJN,

You can save the file (File - Save As) specifying csv or txt as the file
type ("Save as type" at bottom of dialog). Neither, as far as I know, will
put quote marks around all fields -- only those with a field delimiter
(comma) or text qualifier (quote marks) in the actual data. Quote marks
around all fields aren't normally needed. If they are, try the Text Write
Program at www.tushar-mehta.com.
 

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