I don't understand what you're trying to do. Merging (shudder) is usually
done to give the appearance of one cell. However, you state that you want the
2 cells to appear as seperate lines. If you want them to appear seperate, why
nto leave them seperate?

Merging tends to cause so many more problems, as it interferes with copy,
paste, sort, VB, formula extrapolation, etc.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kerry" wrote:

how to merge 2 cells and have them on 2 separate lines in that cell, one
above the other.