Ask Your Question

LibreCalc: =Textjoin (For excel) in librecalc

asked 2018-01-18 16:45:18 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

How can I implement the TEXTJOIN function in librecalc?

edit retag flag offensive close merge delete


Please do not post as community wiki. See guidelines for asking.

Jim K gravatar imageJim K ( 2018-01-18 20:15:53 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-01-19 09:58:46 +0100

peppinosh gravatar image

Thank you. I have updated Librecalc and I have found the new function

edit flag offensive delete link more


This is not an answer, and should be a comment under the question. Also, mark the answer as correct. Please, please read and follow instructions as detailed under guidelines for asking.

Jim K gravatar imageJim K ( 2018-01-19 20:31:55 +0100 )edit

answered 2018-01-18 16:59:42 +0100

Lupp gravatar image

updated 2018-01-18 17:09:22 +0100

TEXTJOIN() ( and CONCAT() ) are implemented in LibreOffice since Version 5.2. There were issues, but since V5.3.3. the function is actually usable.

As I was told, the functions are only availabel in Excel in a small subset of versions.

(I also implementad a similar function in BASIC offering a few additional options, in specific the removal of repetitions from the texts to join. Tell me if you are interested. See also my answer in this thread to find a corresponding TEXTSPLIT() function and a demonstration of its usage.)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-18 16:45:18 +0100

Seen: 2,418 times

Last updated: Jan 19 '18