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