Breaking a line within a formula - HELPHELP PLEASE

[Shirley]

Hello,
You know how you can enter a break in a line by typing ALT + ENTER?
How can you break a line within a formula?
For example, if within one cell I have an equation that is pulling in three
sets of text, and I want the answer to have breaks in the line. When I use
ALT + ENTER it does not recognize the code.
I'm not sure my description is clear...
I have this: ='formula1'&'formula2'&'formua3'
if the answer to formula 1 is 1, and the answer to formula 2 is 2, and the
answer to formula 3 is 3; I get
123
but I want to get
1
2
3
I tried using ALT+ENTER between the formulas. It shows up correctly in the
formula bar, but does not return in the correct format.
CAN ANYONE HELP??

 

[Harald Staff]

Hi Shirley

=A1&CHAR(10)&A2&CHAR(10)&A3

format cell to wrap text

HTH. Best wishes Harald

 

[מיכ×ל (מיקי) ×בידן]

Try:
=A1&CHAR(10)&A2&CHAR(10)&A3
Micky