View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rubeus rubeus is offline
external usenet poster
 
Posts: 1
Default Carriage returns in the formula bar?


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