Formula to wrap text at a certain point

Hi,

I need a formula that will force a carriage return in a cell which concatenates two other cells - something like:

=A1&CHAR(13)&B1

So that the contents of A1 appears above the contents of B1.

ie.
Cell A1="Hi"
cell B1="There"
formula to wrap text and present as:
Hi
There

Can anyone assist?

Thanks

Use CHAR(10) instead of CHAR(13), and ensure the cell is formatted to Wrap Text. You may need to adjust the row height manually to see both lines of text.

Hope this helps.

Pete