Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
karaayn
 
Posts: n/a
Default How do I save an excel spreadsheet as a comma-delimited ASCII file

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default How do I save an excel spreadsheet as a comma-delimited ASCII file

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 Backmann


"karaayn" wrote:

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
karaayn
 
Posts: n/a
Default How do I save an excel spreadsheet as a comma-delimited ASCII file

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?

"karaayn" wrote:

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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default How do I save an excel spreadsheet as a comma-delimited ASCII

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 Backmann


"karaayn" wrote:

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?

"karaayn" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Can I write an excel formula to display the file save date? Bob-123456789 Excel Worksheet Functions 1 January 26th 06 07:50 PM
Weird File Open/Save As Behavior [email protected] Excel Discussion (Misc queries) 0 December 9th 05 02:26 AM
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
Excel How do I create a comma delineated xls file to a comma delineated. Mark Excel Discussion (Misc queries) 0 November 26th 04 10:28 PM


All times are GMT +1. The time now is 04:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"