FG
💻 Software

How can I make a newline in an Openoffice.org Calc formula?

Fresh5 days ago
Mar 15, 202610612 views
Confidence Score0%
0%

Problem

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

Error Output

I2    J2    K2
big   dog   big
            dog

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How can I make a newline in an Openoffice.org Calc formula?

Low Risk

It looks like 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!

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment