How to save an excel spreadsheet as a text file without added quot
 

I'm trying to save an excell spreadsheet as a (tab delimited) text file.
Everytime I try to save it excel decides to add quotes to some of my cells.
How do I get it to stop doing this?
The cells it adds quotes to are cells that already have quotes in them, it
adds extra quotes around the whole cell. I really don't want that
Also cells that have numbers with commas (ie a cell with 64,4) it decides
needs quotes.
So my text file has "64,4" in it instead of 64,4 and "date "4-8-05""
instead of date "4-8-05"

Hi Dozzle-

What you describe is how a Tab Delimited text file works -- the quotes are
referred to as text qualifiers and are placed around cell content to
distinguish it from values (actual number values, currency, dates, etc.).
This is done so that the receiving program can interpret the data more
accurately. The 'additional' quotation marks do not show up when the data
from the file is imported by another data-based program.

Keep in mind that text data files aren't really intended for 'Human
Consumption', so if readability is your concern you may want to consider
another file format for your output.

HTH |:)

"Dozzle" wrote:

I'm trying to save an excell spreadsheet as a (tab delimited) text file.
Everytime I try to save it excel decides to add quotes to some of my cells.
How do I get it to stop doing this?
The cells it adds quotes to are cells that already have quotes in them, it
adds extra quotes around the whole cell. I really don't want that
Also cells that have numbers with commas (ie a cell with 64,4) it decides
needs quotes.
So my text file has "64,4" in it instead of 64,4 and "date "4-8-05""
instead of date "4-8-05"

Well, I'm trying to do a couple things with the data. Mostly I have an excel
spreadsheet that will dump data to an XML file, which I don't want the quotes
in. Also in another instance I'm editing data from a database dump and I
want it to save it exactly the way it was, not add extra quotes.
I tried different file formats but they all did the same thing for me.
Which type of file format should I use?

"CyberTaz" wrote:

Hi Dozzle-

What you describe is how a Tab Delimited text file works -- the quotes are
referred to as text qualifiers and are placed around cell content to
distinguish it from values (actual number values, currency, dates, etc.).
This is done so that the receiving program can interpret the data more
accurately. The 'additional' quotation marks do not show up when the data
from the file is imported by another data-based program.

Keep in mind that text data files aren't really intended for 'Human
Consumption', so if readability is your concern you may want to consider
another file format for your output.

HTH |:)

"Dozzle" wrote:

I'm trying to save an excell spreadsheet as a (tab delimited) text file.
Everytime I try to save it excel decides to add quotes to some of my cells.
How do I get it to stop doing this?
The cells it adds quotes to are cells that already have quotes in them, it
adds extra quotes around the whole cell. I really don't want that
Also cells that have numbers with commas (ie a cell with 64,4) it decides
needs quotes.
So my text file has "64,4" in it instead of 64,4 and "date "4-8-05""
instead of date "4-8-05"