View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default how to merge 2 cells and have them on 2 separate lines in a cell

Try this:

=A1 & CHAR(10) & B1

Then set the cell to wrap text.

CHAR(10) is equivalent to Alt-Enter if you typed it yourself.

Hope this helps.

Pete

On Aug 13, 4:33*pm, Kerry wrote:
how to merge 2 cells and have them on 2 separate lines in that cell, one
above the other.