Try:
=A1&CHAR(10)&B1

Note: Until you go in and change the format so that text wraps, it will
(most likely) look funny and not appear to have worked.

Format-cells-alignment-wrap text
--
Kevin Vaughn


"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?


--
rubeus
------------------------------------------------------------------------
rubeus's Profile: http://www.excelforum.com/member.php...o&userid=36121
View this thread: http://www.excelforum.com/showthread...hreadid=558967