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.
|