Concatenate two text cells with a new line inbetween

Question:

Is there an easy way to use a formula to concatenate two text cells and insert a new line between them?

Answer"

In C1 enter:

=A1&CHAR(10)&B1

Check Wrap text (for the formula cell) on the Alignment tab under Format|Cells.


(Source: http://www.mrexcel.com/forum/excel-questions/20775-concatenate-two-text-cells-new-line-inbetween.html)