software

Is there a way to insert a hard return into a formula that joins text from 2
or more cells?

=B1 amp; B2

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

quot;Sentence 1

Sentence 2quot;Can this be done with a formula?
Thanks,
Paul
try
=b1 amp;quot; quot;amp;b2
format alignment as wrap text and use as many spaces as necessary

--
Don Guillett
SalesAid Software

quot;PCLIVEquot; gt; wrote in message
...
gt; Is there a way to insert a hard return into a formula that joins text from
gt; 2 or more cells?
gt;
gt; =B1 amp; B2
gt;
gt; I'd like to have 2 hard returns after B1. Is this possible? The result
gt; of the formula should appear as:
gt;
gt; quot;Sentence 1
gt;
gt; Sentence 2quot;
gt;
gt;
gt; Can this be done with a formula?
gt; Thanks,
gt; Paul
gt;
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

quot;Don Guillettquot; gt; wrote in message
...
gt; try
gt; =b1 amp;quot; quot;amp;b2
gt; format alignment as wrap text and use as many spaces as necessary
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;PCLIVEquot; gt; wrote in message
gt; ...
gt;gt; Is there a way to insert a hard return into a formula that joins text
gt;gt; from 2 or more cells?
gt;gt;
gt;gt; =B1 amp; B2
gt;gt;
gt;gt; I'd like to have 2 hard returns after B1. Is this possible? The result
gt;gt; of the formula should appear as:
gt;gt;
gt;gt; quot;Sentence 1
gt;gt;
gt;gt; Sentence 2quot;
gt;gt;
gt;gt;
gt;gt; Can this be done with a formula?
gt;gt; Thanks,
gt;gt; Paul
gt;gt;
gt;
gt;

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

--
yellowbeetle
------------------------------------------------------------------------
yellowbeetle's Profile: www.excelforum.com/member.php...oamp;userid=31326
View this thread: www.excelforum.com/showthread...hreadid=510092=B1amp;CHAR(10)amp;CHAR(10)amp;B2

set wraptext and widen the row to suit

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;PCLIVEquot; gt; wrote in message
...
gt; Is there a way to insert a hard return into a formula that joins text from
2
gt; or more cells?
gt;
gt; =B1 amp; B2
gt;
gt; I'd like to have 2 hard returns after B1. Is this possible? The result
of
gt; the formula should appear as:
gt;
gt; quot;Sentence 1
gt;
gt; Sentence 2quot;
gt;
gt;
gt; Can this be done with a formula?
gt; Thanks,
gt; Paul
gt;
gt;
Very good Bob! That's exactly what I was looking for.

Thanks for your help.
Paul

quot;Bob Phillipsquot; gt; wrote in message
...
gt; =B1amp;CHAR(10)amp;CHAR(10)amp;B2
gt;
gt; set wraptext and widen the row to suit
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;PCLIVEquot; gt; wrote in message
gt; ...
gt;gt; Is there a way to insert a hard return into a formula that joins text
gt;gt; from
gt; 2
gt;gt; or more cells?
gt;gt;
gt;gt; =B1 amp; B2
gt;gt;
gt;gt; I'd like to have 2 hard returns after B1. Is this possible? The result
gt; of
gt;gt; the formula should appear as:
gt;gt;
gt;gt; quot;Sentence 1
gt;gt;
gt;gt; Sentence 2quot;
gt;gt;
gt;gt;
gt;gt; Can this be done with a formula?
gt;gt; Thanks,
gt;gt; Paul
gt;gt;
gt;gt;
gt;
gt;