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?
I2 J2 K2 big dog big dog
I've tried using Ctrl-Enter in various places and char(10) and char(13) to no avail. The newline always disappears.