The villain may also be the ‘@’ format code (‘Text’) set under ‘Numbers’ for the cell.
I probably didn’ find something “wrong with the function” because I used it properly in calculating cells under appropriate settings.
BTW1: “wtf” and “mate” aren’t cells but constant texts.
BTW2: There is not only the CONCATENATE function, but also the infix operator
& for concatenation. A simple formula like
=A1 & A2 might be preferable compared with
BTW3: Also try TEXTJOIN if your LibO version is V 5.3.x or higher. Unfortunately there isn’t yet a useful helptext for the function. If using the function wizard: Tex1 and the following parameters also accept ranges and calculated arrays (needing array-evaluation in the last case).
BTW4: It’s often the users with their first and only question using insults and showing a lordly attitude. I cannot remember a case where such a user later also posted useful help for others. They don’t understand the community nature of forums. (So, why should they understand the software which is much more complicated?)