Open the function wizard.
There is a function CONCAT (which allows to accept cell ranges). This function isn't part of the help of LO. Only CONCATENATE is part of the help and this function doesn't accept cell ranges.
Tested with LO 220.127.116.11 on OpenSUSE 64bit rpm Linux.
Version: 18.104.22.168.alpha0+ (x64)
Build ID: bf2f0c913774c90e4c9a65119d0219187bb4498c
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win;
Locale: de-DE (de_DE); UI-Language: en-US
We could add TEXTJOIN() that it's similar to CONCAT() but a bit powerful. That also has no help.
TEXTJOIN(Delimiter, Skip empty cells, Text1, Text2,..)
Combines several text items into one, accepts cell ranges as arguments.
Uses delimiter between items.
*** This bug has been marked as a duplicate of bug 99517 ***