S Sandy Jul 27, 2009 #1 i am merging a few cells into one, but want them to appear on 3 separate lines. char(10) does not seem to be working.
i am merging a few cells into one, but want them to appear on 3 separate lines. char(10) does not seem to be working.
T T. Valko Jul 27, 2009 #2 You have to format the cell to wrap text. A1:A3 = merged cells Entered this formula: ="Line1"&CHAR(10)&"Line2"&CHAR(10)&"Line3" Goto the menu Format>Cells>Alignment tab>Wrap Text>OK The result of the formula appears as: Line1 Line2 Line3 You may have to adjust the row height to get the exact fit you want.
You have to format the cell to wrap text. A1:A3 = merged cells Entered this formula: ="Line1"&CHAR(10)&"Line2"&CHAR(10)&"Line3" Goto the menu Format>Cells>Alignment tab>Wrap Text>OK The result of the formula appears as: Line1 Line2 Line3 You may have to adjust the row height to get the exact fit you want.
