Create carriage return using "=A1&A2" text merge?

[kselig]

I want to merge text from multiple cells, displaying each cell's text on a
new line (ie, a carriage return). I merged the text using "=A1&A2" putting
the text in A3. The problem is that the text runs together. How do I place
the text from A1 on the first display line and the text from A2 on the second
line? You can do this when typing text into a cell by using the Ctrl-Return
concept, but this does not work in the merge function.

Thanks

 

[Biff]

See other post in .MISC

Biff

 

[Guest]

Use this formula in A3:
=A1&CHAR(10)&A2

Set the A3 Format to Wrap Text. From the Format menu:
- Format Cells
- Alignment Tab
- Under "Text control", Select the "Wrap text" checkbox