Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

ASCII

Posted by Dave Simpson on June 13, 2001 7:58 AM
How do I save an Excel file in ASCII format?

Re: ASCII

Posted by Mark W. on June 13, 2001 8:04 AM
Do you mean text format?


Re: ASCII

Posted by Eric on June 13, 2001 9:34 AM
There are a couple of ASCII compatible formats.
In File-->Save As there's a window called
"save as type" check the drop down menu for different options, the most ASCII friendly one (IMHO) is Text Tab delimited (easy to get back into an excel format). There's also Formatted text(space delimited-can screw you up if there are spaces in the data in your cells), CSV, as well as text and csv for mac or dos. Most of my experience is with tab-delimited, but you should play around with them and see what works the best for you.


BTW, saving to ASCII only keeps the active worksheet!

Posted by Eric on June 13, 2001 9:35 AM
So you'll have to make one ascii compatible file per worksheet, not workbook.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.