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.
 
That did the trick.
Thanks for your help.

Peo Sjoblom said:
You have to format wrap text under format>cells>alignment

--

Regards,

Peo Sjoblom

the
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedding <CR>'s in formulas eases eye strain. 1
Index with partial text 1
referencing cells with carriage returns 1
Unicode text and carriage returns 4
Carriage return in a text cell 3
Splitting text divided by carriage returns 2
Macro to insert a line when a value changes in a range 1
Excel: How to insert carriage returns in a formula to manipulate t 1

Back
Top