How can I concat cellvalues with new line in MS Excel?

concatenation, excel, newline

Solution

In A3 enter:

=A1 & CHAR(10) & A2

and format A3 for wrap text

Problem

In excel I can introduce a new line inside a cell with a `[alt enter]` ``` Boo[alt enter]Far ``` results in: ``` Boo Far ``` Now `A1` contains `Boo`, `A2` contains `Far`. How can I display these values in `A3` separated with a new line? ``` A3=A1[alt enter]&B1 ``` results in BooFar ``` A3=A1&[alt enter]B1 ``` results in BooFar How can I get ``` Boo Far ``` By using cell references?

Original source