TEXTJOIN

Concatenates one or more strings, and uses delimiters between them.

αƒ‘αƒ˜αƒœαƒ’αƒαƒ₯αƒ‘αƒ˜

TEXTJOIN( delimiter, skip_empty, String 1[; String 2][; … ;[String 253]] )

delimiter is a text string and can be a range.

skip_empty is a logical argument. When set to FALSE or 0, empty strings will be taken into account and this may lead to adjacent delimiters in the returned string. When set to any other value (e.g. TRUE or 1), empty strings will be ignored.

String 1[; String 2][; … ;[String 253]] are strings, references to cells or to cell ranges of strings.

Ranges are traversed row by row (from top to bottom).

If delimiter is a range, the range need not be of the same size as the number of strings to be joined.

If there are more delimiters than strings to be joined, not all delimiters will be used.

If there are less delimiters than strings to be joined, the delimiters will be used again from the start.

αƒ›αƒαƒ’αƒαƒšαƒ˜αƒ—αƒ”αƒ‘αƒ˜

=TEXTJOIN(" "; 1; "Here"; "comes"; "the"; "sun") returns "Here comes the sun" with space character as delimiter and empty strings are ignored.

if A1:B2 contains "Here", "comes", "the", "sun" respectively, =TEXTJOIN("-";1;A1:B2) returns "Here-comes-the-sun" with dash character as delimiter and empty strings are ignored.

Technical information

tip

This function is available since LibreOffice 5.2.


This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.TEXTJOIN

Please support us!