"rubeus" wrote in
message ...

Hi, I have a large table which needs many columns (too many to do
manually with alt-enter) joined together in this particular way:

A1: textA
B1: textB

I need to join these two cells with a carriage return like so:

C1: textA
textB

Everything I have tried as a carriage return has only given me the
□ character instead of a carriage return. Is there a way to do
this?

=A1&CHAR(10)&B1
(and remember to format C1 with text wrapping enabled).
--
David Biddulph