https://bugs.documentfoundation.org/show_bug.cgi?id=155805
Bug ID: 155805
Summary: Support for string concatenation with separator
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I want to be able to concatenate strings with a separator between them, but
such that the separator is only used for non-empty string, i.e. with separator
" ",
"Foo", "Bar", "" => "Foo Bar"
"Foo", "", "Baz" => "Foo Baz"
"Foo", "", "" => "Foo"
the CONCAT and CONCATENATE functions don't offer this functionality (see also
text/scalc/01/func_concat.html in the help docs).
--
You are receiving this mail because:
You are the assignee for the bug.