I can save an xls as a csv comma-delimited file, but I don't think its in the
ASCII format and can't find ASCII on the list of save as file formats.
Select FILE from the menu and click SAVE AS. From the SAVE AS dialog box
drop down the selection list for the SAVE AS TYPE combo box. Select CSV
(comma delimited)(*.csv) as the file type.
--
Kevin Backmannquot;karaaynquot; wrote:
gt; I can save an xls as a csv comma-delimited file, but I don't think its in the
gt; ASCII format and can't find ASCII on the list of save as file formats.
The csv file I made did not work (as a class properties file in Fragstats),
and I could try a txt file instead but I see no options in Excel for
comma-delimited txt files (only tab or space). Any suggestions out there?
quot;karaaynquot; wrote:
gt; I can save an xls as a csv comma-delimited file, but I don't think its in the
gt; ASCII format and can't find ASCII on the list of save as file formats.
Do you have MS Access on your PC. If you do you can either link to
spreadsheet as a table or import your excel data into a table. From Access
you would have a wider array of choice for exporting your data to a text file.
--
Kevin Backmannquot;karaaynquot; wrote:
gt; The csv file I made did not work (as a class properties file in Fragstats),
gt; and I could try a txt file instead but I see no options in Excel for
gt; comma-delimited txt files (only tab or space). Any suggestions out there?
gt;
gt; quot;karaaynquot; wrote:
gt;
gt; gt; I can save an xls as a csv comma-delimited file, but I don't think its in the
gt; gt; ASCII format and can't find ASCII on the list of save as file formats.
- Nov 18 Sat 2006 20:10
How do I save an excel spreadsheet as a comma-delimited ASCII file
close
全站熱搜
留言列表
發表留言