View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE
 
Posts: n/a
Default Hard returns in a formula?

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