=B1&CHAR(10)&CHAR(10)&B2

set wraptext and widen the row to suit

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"PCLIVE" wrote in message
...
Is there a way to insert a hard return into a formula that joins text from
2
or more cells?

=B1 & B2

I'd like to have 2 hard returns after B1. Is this possible? The result
of
the formula should appear as:

"Sentence 1

Sentence 2"


Can this be done with a formula?
Thanks,
Paul