Given some sheet at cell
A1 if I write
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?