View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Craig Craig is offline
external usenet poster
 
Posts: 208
Default Saving text with commas in a .csv file then converting to a .txt f

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!