In C1 enter =A1 & CHAR(10) & B1

Double-click on the fill handle of C1 to copy down.

Format Column C to wrap text.


Gord Dibben MS Excel MVP


On Thu, 6 Jul 2006 10:56:28 -0500, rubeus
wrote:


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?