Hi Bruce
try
=A1 & CHR(10) & B1
also format the target cell with word wrap

--
Regards
Frank Kabel
Frankfurt, Germany


Bruce N. wrote:
I have a question about the concatenate function. How do you
concatenate two or more cells, so that when they appear in the target
cell, the first cell is in the top line, and the second cell is on
the next line like if you pressed <alt,<enter within the cell, if
you were entering it manually as opposed to using the formula.