Concatenate text with a carriage-return

  • Thread starter Thread starter ks_mail_2003
  • Start date Start date
K

ks_mail_2003

Hi,

I have two cells with the following text;
A1 = "abc"
B1 = "def"

I want to concatenate these two text into C1 with a carriage-return
(alt-enter) in between.

The text in C1 should be;
"abc
def"

Thanks in advance,
ks.
 
=a1&char(10)&b1

Remember to turn wraptext on, else you'll get a little square instead.
 
Back
Top