saving file as text(tab delimited)...

[Sevgi]

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]

I think it's because your windows list separator is a semicolon.

I put test;test in A1 (and have a comma as my list separator). xl didn't add
that double quotes.

You could either change that separator (under windows control panel) or use your
own macro to write exactly what you want.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html


If you don't want to write your own, try Earl's program first. He has lots of
options in that program.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm