Concatenate text with a carriage-return

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

 

[Dave Peterson]

=a1&char(10)&b1

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