Home |
Search |
Today's Posts |
#1
|
|||
|
|||
saving file as text(tab delimited)...
Hi,
I use Excel 2003. For example I write test;test1 in A1 and save as the file text(tab delimited)(*.txt). I open the saved file, it write "test;test1". If a cell contains semicolon between text, after saving file as text(tab delimited)(*.txt), it places quotation marks. Why it puts quotation marks? And how can I configure excel not put quotation marks? Note: Replacing quotation marks in saved text file is not a solution for me. Thanks and best regards. Sevgi. |
#2
|
|||
|
|||
See one guess at your first response.
Sevgi wrote: Hi, I use Excel 2003. For example I write test;test1 in A1 and save as the file text(tab delimited)(*.txt). I open the saved file, it write "test;test1". If a cell contains semicolon between text, after saving file as text(tab delimited)(*.txt), it places quotation marks. Why it puts quotation marks? And how can I configure excel not put quotation marks? Note: Replacing quotation marks in saved text file is not a solution for me. Thanks and best regards. Sevgi. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) |