In cell A1 I have the value:
test
in cell C1 I have the formula:
=A1 & CHAR(10) & "attempt"
when I copy the value of C1 to Notepad++.exe it adds double quotes around the value.ie:
"test
attempt"
What will allow me to copy the formula (with my line break) so that no double quotes are added?
expected result:
test
attempt
