New Line in a formula (Alt-Enter)

[erajim]

I am trying to create a formula in a cell to put together two cells, but I want to include a new line between them.

Example:
Cell1
5050 Encinas Ave

Cell2
San Diego, Ca.

Cell3 (this is how I want it to look - I am aware I can individually do Alt - Enter - but how do I put that in a formula?)
5050 Encinas Ave
San Diego, Ca.

I don't want cell3 to look like this one all one line in the cell
5050 Encinas Ave San Diego, Ca

[VBA Noob]

Try

=A1&CHAR(10)&A2

then format the formula cell as wrapped text

VBA Noob

[erajim]

Noob,
thanks for the quick reply. However I typed it exactly and it just puts the formula in the new cell - not the results.

[erajim]

Noob,
for some reason I inserted another column and then tried your formula and then it worked!

Not sure why it wouldn't work in the column I was using.

SO THANKS A LOT!!!!!!!