Breaking a line within a formula - HELPHELP PLEASE
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?? -- Shirley |
Breaking a line within a formula - HELPHELP PLEASE
Hi Shirley
=A1&CHAR(10)&A2&CHAR(10)&A3 format cell to wrap text HTH. Best wishes Harald "Shirley" wrote in message ... 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?? -- Shirley |
Breaking a line within a formula - HELPHELP PLEASE
Try:
=A1&CHAR(10)&A2&CHAR(10)&A3 Micky "Shirley" wrote: 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?? -- Shirley |
All times are GMT +1. The time now is 04:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com