Forcing a Paragraph

[nickharr]

I have a worksheet with various columns of descriptions and I need to make a new column to merge two of the other columns together using a fomula like = a1&b1 but I really need the result to show as two different paragraphs instead of being in one line.
Could anyone please tell me how I could achieve this? Thanks

 

[VoG]

Try

=A1&CHAR(10)&B1

format the cell to wrap text.

 

[Andrew Poulsom]

Try:

=A1&CHAR(10)&B1

and format the cell as Wrap text.

 

[nickharr]

Brilliant! Thanks very much - works perfectly.