Hope you are all well.
I was wondering whether it is possible to export Excel files to Text (tab delimited) (*.txt) without inserting unwanted " 's please?
The task I am trying to automate is the removal of unwanted characters, one of which is the double-quotation mark.
I have written...
Excel is inserting "unwanted quote marks" around text fields containing commas or other special characters when exporting a file in "tab-delimited" format.
Is there a standard option or something to disable this behaviour without having to write a macro to prevent it?