Concatenate Function

[stmts]

How can I concatenate 2 cells and have the data in the receiving cell appear
in 2 lines. For example:
Cell A1 = 4844 Jones Street
Cell B1 = Harrisburg, Pa 17111

I want the receiving cell,C1, to have two lines such as
4844 Jones Street
Harrisburg, Pa 17111

Can I do this? Can anyone help?

Thanks,
Lou

 

[Myrna Larson]

Edit the cell after you've combined the text. Move to the point where you want
the line break, hold down the ALT key and press ENTER.