software

Hi

Need to do the following.

Have C1 = A1amp;B1 but required to have C1 display as 2 lines

A1
B1

i.e. as if Alt-Enter had been used in cell.

Have tried using alt-010 in middle of A1amp;B1 formula.

How can I get alt-enter into the formula?

Thanks for any help

Regards
Max--
MaxBrit
------------------------------------------------------------------------
MaxBrit's Profile: www.excelforum.com/member.php...foamp;userid=7465
View this thread: www.excelforum.com/showthread...hreadid=500553in C1: =A1amp;CHAR(10)amp;B1
and format C1 with word wrap!

Regards,
Stefi

?axBrit??ezt ?rta:

gt;
gt; Hi
gt;
gt; Need to do the following.
gt;
gt; Have C1 = A1amp;B1 but required to have C1 display as 2 lines
gt;
gt; A1
gt; B1
gt;
gt; i.e. as if Alt-Enter had been used in cell.
gt;
gt; Have tried using alt-010 in middle of A1amp;B1 formula.
gt;
gt; How can I get alt-enter into the formula?
gt;
gt; Thanks for any help
gt;
gt; Regards
gt; Max
gt;
gt;
gt; --
gt; MaxBrit
gt; ------------------------------------------------------------------------
gt; MaxBrit's Profile: www.excelforum.com/member.php...foamp;userid=7465
gt; View this thread: www.excelforum.com/showthread...hreadid=500553
gt;
gt;


Stefi

Many thanks for reply.

Max--
MaxBrit
------------------------------------------------------------------------
MaxBrit's Profile: www.excelforum.com/member.php...foamp;userid=7465
View this thread: www.excelforum.com/showthread...hreadid=500553