Concatenate with line breaks

[jongooligan]

I've inherited a workbook with data like this:

A1 = 1 The House B1 = Anytown

In C1 if I use =A1&" "&B1 it returns 1 The House Anytown

What I need in C1 is:

1 The House
Anytown

There are 7 cells that contain a different address line so how do concatenate them with line breaks?

 

[Richard Schollar]

Hi

=A1 & CHAR(10) & B1

and format this formula cell to Wrap Text (ie Format>Cells>Alignment tab and check Wrap Text).

 

[jongooligan]

Thanks, I was working along those lines but couldn't figure out which char() was the line break.