It is my experience that, when you open a renamed csv file, on the first
screen, it will show """ around text. However, with your text identifier set
to ", when you click on finish, it will open correctly, eg """text""" becomes
"text".

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Craig" wrote:

I need to get an Excel sheet (Office 2007) into a text format that is comma
seperated with quotations around the cells that contain text.

I can save the sheet as a .csv file which handles the commas, but when I
change the file extension to a .txt type I end up getting quotations around
the existing quotes. For example "test" in the .csv file appears as
"""test""" when I open it in the .txt file.

Any ideas?

Thanks in advance!