excel dos txt save

I need to save a sheet in dos .txt format but when I save
it excel put " quotes" on each side of the first colum.
Does anyone no how to get rid of the " "
thanks

Hi Tim,
Maybe I should type something before I send.

I haven't been able to duplicate this problem in Excel 97.

However, You could open the .txt file in WORD and the use EditReplace. Enter " for the Find What, and leave the Replace With field empty.


Good Luck,
Mark Graesser

Boston MA

----- TIM wrote: -----

I need to save a sheet in dos .txt format but when I save
it excel put " quotes" on each side of the first colum.
Does anyone no how to get rid of the " "
thanks

Excel will automatically place the values in " when it is non-numeric data
AND if the value of the field includes either a , or ". Commas are the
indication of the division between a cell, so if a cell's data contains a ,
then " must be added to make sure everything goes in one cell. Therefore, "
inside a cell must be replaced with two quotes.

So, what I always do in this situation is to create a separate column which
contains the following formula:
="~"&A1&"~"
This creates a colunm with your values with a ~ on either side. Then copy
the resulting column, shoose Paste-Special-Values on top of the original
column, and delete your temporary column. Now save the file, open it in a
text editor and replace all occurances of "~ and ~" with blanks, then
replace all "" with " and you'll ahve the file you want.

By the way, if you use this file to load data into a database, you'll need
to leave those extra quotes in there. the database interprets the data the
same way excel does, so it knows what those quotes are for.

"TIM" wrote in message
...
I need to save a sheet in dos .txt format but when I save
it excel put " quotes" on each side of the first colum.
Does anyone no how to get rid of the " "
thanks