up vote 1 down vote favorite
1
share [g+] share [fb]

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.

link|improve this question
89% accept rate
feedback

2 Answers

up vote 1 down vote accepted

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!

link|improve this answer
1  
The behavior in general is fixed in OpenOffice 3.2: openoffice.org/dev_docs/features/3.2/#calc_newlines – Jim Hunziker Mar 13 '10 at 20:17
feedback
up vote 0 down vote

On Linux you can use:

=CONCATENATE("line 1";char(10);"line2")
link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.