Insert carriage return between 2 text fields

  • Thread starter Thread starter Gerd
  • Start date Start date
G

Gerd

I would like to copy the text of 2 cells into a 3rd but with a <CR> in
between. The result should be as if I had entered ALT+ENTER between the 2
texts.
 
Gerd said:
I would like to copy the text of 2 cells into a 3rd but with a <CR> in
between. The result should be as if I had entered ALT+ENTER between the 2
texts.
Click to expand...

Hi Gerd,

Try : "Text 1" & CHR(10) & "Text 2"

Regards

Jean
 
Hi Gord,

I had already tried that but the result is that the text is concatenated
into 1 line instead of 2 lines within the same cell. The ALT ENTER is still
missing.
 
Back
Top