Hard returns in a formula?

[PCLIVE]

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

[Don Guillett]

try
=b1 &" "&b2
format alignment as wrap text and use as many spaces as necessary

--
Don Guillett
SalesAid Software
[email protected]
"PCLIVE" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[yellowbeetle]

One can also try the key combination Alt-Enter while edit the cell formula.

[PCLIVE]

Don,

This doesn't work due to a limit in formula length. Maybe there's another
way to do this.

I have a textbox that is populated by joining the text from multiple cells.
However, I need the final output (textbox) to be displayed with some hard
returns. This textbox is supposed to be sort of a preview of what the body
text of an email will look like when sent.

I hope this makes since.

Paul

"Don Guillett" <[email protected]> wrote in message
news:[email protected]...
> try
> =b1 &" "&b2
> format alignment as wrap text and use as many spaces as necessary
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "PCLIVE" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>
>

[Bob Phillips]

=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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[PCLIVE]

Very good Bob! That's exactly what I was looking for.

Thanks for your help.
Paul

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> =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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>
>