Concatenate Function

L

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
 
B

Biff

Hi!

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

=A1&char(10)&B1

Biff
 
F

Frank Kabel

Hi
enter
=A1 & CHAR(10) & B1

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