How to enter line breaks in formula?
I want to use TEXT.JOIN()
function but I need to add as delimiter a new line, how do I do?
First time here? Check out the FAQ!
I want to use TEXT.JOIN()
function but I need to add as delimiter a new line, how do I do?
Control character #10 is newline.
In a formula you can insert CHAR(10)
as an element to be joined. This works well with the TEXTJOIN()
function.
Asked: 2020-02-14 13:54:20 +0100
Seen: 1,389 times
Last updated: Feb 14 '20
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]