Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving an excel file as text without text in quotes
I am creating a comma delimited (text) file for upload to another
application. The file is a tab in Excel (2000). No matter what (.txt) file format I select to save as, each line of the output file is in quotes (which are not present in the excel source file. As a result, the upload application doe not recognize the data. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving an excel file as text without text in quotes
Start with a completely blank worksheet.
Put hello world in cell A1 Save the file as .csv Open the resulting file with Notepad You should see no quotes -- Gary's Student "John" wrote: I am creating a comma delimited (text) file for upload to another application. The file is a tab in Excel (2000). No matter what (.txt) file format I select to save as, each line of the output file is in quotes (which are not present in the excel source file. As a result, the upload application doe not recognize the data. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving an excel file as text without text in quotes
Mr. Student:
thanks for your reply. I followed your directions. I opened a fresh workbook (book3.xls). I copied column A of my Excel worksheet output data tab (already pasted special as value from my input tab) and pasted it to column A of sheet1 of book3.xls. Then i selected <file <save as and changed the file save as type to CSV (Comma delimited) (*.csv) using the default Filename (i.e. - Book3.csv). This is what is in cells A1:A2 of the output dab of my source workbook: D/0001, ,06/30/05,1,170,11510,1366.87 T/0001, ,06/30/05,1,1,2005-06 Interest Income - V&H Note this is what the first two lines of book3.csv contain when I open it with Notepad: "D/0001, ,06/30/05,1,170,11510,1366.87" "T/0001, ,06/30/05,1,1,2005-06 Interest Income - V&H Note" Do you have any other suggestions? Cordially, John "Gary''s Student" wrote: Start with a completely blank worksheet. Put hello world in cell A1 Save the file as .csv Open the resulting file with Notepad You should see no quotes -- Gary's Student "John" wrote: I am creating a comma delimited (text) file for upload to another application. The file is a tab in Excel (2000). No matter what (.txt) file format I select to save as, each line of the output file is in quotes (which are not present in the excel source file. As a result, the upload application doe not recognize the data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i convert text file to excel file ? | New Users to Excel | |||
How to save an excel spreadsheet as a text file without added quot | Excel Discussion (Misc queries) | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
Excel Creating Temporary File After Saving | Excel Discussion (Misc queries) | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) |