Hard returns in a formula?
Very good Bob! That's exactly what I was looking for.
Thanks for your help.
Paul
"Bob Phillips" wrote in message
...
=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
|