Quotation marks appearing when using CHR() as an argument with concatenation

[AnnieMcken]

Hi again!

When concatenating text content in cells, and then pasting the content of the resulting cell in a txt file without any format, the resulting line is as expected

Example:

A1=AAA
B1=BBB
C1=CCC

=Concatenate(A1;B1;C1) results in AAABBBCCC and pastes as AAABBBCCC.

However, when using CHR(10) or CHR(13) in the function to include a line break:

=Concatenate(A1;B1;CHR(10);C1) results in
AAABBB
CCC

but pastes as
"AAABBB
CCC"

WITH the quotation marks.

Any clues as to how to keep the expression as is? The marks don't appear anywhere in Excel...

Thanks

[ranman256]

It has to do this to understand it is a text with a break in it.
(xl is kinda stupid)

[AnnieMcken]

Ok, this might not be the best solution to this problem, but I found a way:

1. Special-copy the selected cells in Word with the RTF option
2. Select the new table
3. Use the "convert table to text" function.

It does give the desired end result, getting rid of all quotation marks.

So I am writing this in case someone tries to do the same! (Slim chance, but you never know!)