How can I make a newline in an Openofficedotorg Calc formula?

How can I make a newline in an Openofficedotorg Calc formula? I have a text cell I2 and a text cell J2. I want cell K2 to be the contents of I2 concatenated with a newline and the contents of J2. How can I do this?
Asked by: Guest \| Views: 418

Total answers/comments: 2

Comments display order:

Guest [Entry]

It looks like char(10) actually did the trick, but it's just not visible in the sheet. When the data from the spreadsheet is used in a mail merge later (for address labels), the newline is there!

Guest [Entry]

"Type CTRL+Enter in an unused cell, then in the formula for K2 use I2&(address of the cell with the CTRL+Enter)&J2

I stumbled upon it by accident (playing a hunch) and it displays correctly and prints correctly..."