P
plh
The result of this formula:
=CONCATENATE("#1=",W4,CHAR(13),CHAR(10),"GOTO665",CHAR(13),CHAR(10),"N5",Y4)
has quotation marks when copy pasted into a text editor, like so:
"#1=2
GOTO665
N553"
You can see that the CR/LF comes out but it adds the quotation marks.
Is there any cure for this?
Thanx,
-plh
PS:
I tried using only CHAR(13) in place of CHAR(13),CHAR(10) and also
CHAR(10) only, and also using cell references in place of the literal
strings, that is:
=CONCATENATE($Y$1,W3,CHAR(13),CHAR(10),$AA$1,CHAR(13),CHAR(10),$Z
$1,Y3)
but the result was the same.
=CONCATENATE("#1=",W4,CHAR(13),CHAR(10),"GOTO665",CHAR(13),CHAR(10),"N5",Y4)
has quotation marks when copy pasted into a text editor, like so:
"#1=2
GOTO665
N553"
You can see that the CR/LF comes out but it adds the quotation marks.
Is there any cure for this?
Thanx,
-plh
PS:
I tried using only CHAR(13) in place of CHAR(13),CHAR(10) and also
CHAR(10) only, and also using cell references in place of the literal
strings, that is:
=CONCATENATE($Y$1,W3,CHAR(13),CHAR(10),$AA$1,CHAR(13),CHAR(10),$Z
$1,Y3)
but the result was the same.