<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - A little improvement to CONCATENATE/CONCAT, please?" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123001#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - A little improvement to CONCATENATE/CONCAT, please?" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123001">bug 123001</a> from <a class="email" href="mailto:turbobeholder@mail.ru" title="TBeholder <turbobeholder@mail.ru>"> TBeholder</a> <pre>(In reply to Eike Rathke from <a href="show_bug.cgi?id=123001#c3">comment #3</a>) > sounds like you want to use the TEXTJOIN() function where you can specify a > separator and whether empty cells/strings should be concatenated That does it, indeed. Thanks! "TEXTJOIN" is not be found in help (Version: 6.1.2.1), however. Though there are tips for it in Function Wizard. I guess the bug should be changed to "please add basic documentation for TEXTJOIN()" now.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>