Concatenate Function

[Lou]

How can I concatenate 2 cells and have each cell appear in the receiving cell
on separate lines? For example:

cell A1 = 4088 Jones Street
cell A2 = Harrisburg, Pa 17109

Desired result in cell A3 = 4088 Jones Street
Harrisburg, Pa 17109

Thanks for the help,
Lou

 

[Biff]

Hi!

In cell C1 enter this formula and format the cell to wrap text:

=A1&char(10)&B1

Biff

 

[Frank Kabel]

Hi
enter
=A1 & CHAR(10) & B1

and also format the target cell with word wrap ('Format - Cells -
Alignment)

 

[stmts]

Thank you all for the help. Keep up the good work.
Lou