How can I split a formula into multiple lines in OpenOffice calc?
- by cherouvim
I have this simple formula:
=CONCATENATE("foo";"bar")
which renders foobar on the cell.
How can I lay this formula in multiple lines in the same cell? I'd like to be able to do something like the following but it doesn't work as the newline in the cell forbids the formula from being executed:
=CONCATENATE("foo";
"bar")
The reason I'm asking is because I have huge formulas an I need to format them (using newlines and a bit of indentation) for readability.
thanks