Excel - Prevent quotes when using concatenate with new lines

Question

When using concatenate with char(10), my output ends up being wrapped in quotes when I cut and paste the value to a new application.

e.g. =concatenate("A",char(10),"B") produces:

"A
B"

in Notepad.

Anyone know how to suppress the quotes? (this only seems to happen with concatenate + new lines).

Answer 1

This is not exactly a solution to your problem but if you paste it in MS Word, you won't get the quotes. If your requirement is to see the data without quotes, this may help.