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.

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