I am using a formula with char(10) to create carriage returns in output text. This seems to be having a side effect of duplicating my quotation marks - changing " to "".
This does not show in Excel, but only shows when the values are pasted into notepad. Is there a way to format my Excel formula so it does not display the paired double quotation marks?
See attached spreadsheet for my examples.