- #1
- 45,584
- 2,289
I'm trying to save an Excel spreadsheet as a (tab-delimited) text file for input into another database. For some reason, fields containing a comma are being displayed in the text file within quotes, which I don't want. For example:
What I want to see is:
Is there any clever way of saving the Excel file so I don't have those quotes?
John Doe appears as: John Doe
Doe, John appears as: "Doe, John"
Doe, John appears as: "Doe, John"
What I want to see is:
John Doe appearing as: John Doe
Doe, John appearing as: Doe, John
Doe, John appearing as: Doe, John
Is there any clever way of saving the Excel file so I don't have those quotes?