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

You can do it with Alt-Return, but the formulas have a nasty tendency to not
work then.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dave" wrote in message
...
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

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