That is just what I needed, worked perfect.

Thanks

"Pete_UK" wrote:

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.