Like in this simple example on Google Sheet I have a formula to create an official note we add on invoices in QuickBooks which is a concatenation of cells and words.

The formula on cell C1 will show the result below:

This works as intended except that when I copy cell C1 and paste on an invoice on Quickbooks it always includes the double qoutes before the word CASE and after the word RESOLVED. Is there a way to exclude this from the result? I tried changing CHAR(10) to CHAR(13) but it doesn’t help, this seem to work fine when pasting on a Gmail email but not on other forms like a Quickbooks Invoice.