Hi Dave

=A1&CHAR(10)&B1
Make sure the cell is preformatted with "wrap text".

HTH. Best wishes Harald

"Dave" skrev i melding
...
I want to insert carriage return in the middle of a text formula to force
the
resulting text to wrap at a specific point. It would be the same thing as
pressing Alt/Return while entering text manually except that the text is
being created in a formula.
--
Dave