Insert carriage return between 2 text fields

[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.

 

[Jean Ruch]

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.

Hi Gerd,

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

Regards

Jean

 

[Gord Dibben]

Gerd

=A1 & Char(10) & B1

Gord Dibben XL2002

 

[Gerd]

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.

 

[Peo Sjoblom]

You have to format wrap text under format>cells>alignment

 

[Gerd]

That did the trick.
Thanks for your help.

You have to format wrap text under format>cells>alignment

--

Regards,

Peo Sjoblom

the

 

[Gord Dibben]

Yep.

That's the part I left out.

Gord