Excel adds quotation marks to comma separated text during save operation
Posted on 2007-10-01
I import a t ext file (fixed width although records have commas) for processing in Excel. Due to changes in how the processing works, the file is imported into a workbook where the code is at. After processing, when I save the sheet back to text format (I have tried all.txt options), it adds quotation marks around the text where it is separated by commas. I noticed that you just open the file as fixed width and save it, it does not add the quotes. This only happens when I open the file, copy it to a new workbook and try to save it from there. Does anyone know how to prevent Excel from adding quotes to the records?