=A1&CHAR(10)&A2

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bruce N." wrote in message
...
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.