I know I can press CTRL+Enter to create multiline text within cells. But how do I create these using formulas? I tried to use the escape sequence “\n” but it did not work. Thanks.
="1" & CHAR(10) & "2"
And you may need to change the vertical alignment of the cell to see all the lines.
Very good. Thanks.