Given some sheet at cell A1 if I write =foo\nbar then foo\nbar will be rendered as shown:If I manually add a newline using the shortcut cmd + opt + enter then the expected output as shown:It's a problem because it makes my formulas look bad, especially if I'm adding a title row with ARRAYFORMULA.Is it possible to get some type of newline character interpolated?How do you format your multiline formulas?
Treat \n as a newline character for multiline formulas
google spreadsheets