Documentation/Calc Functions/TEXTJOIN

Function name:
TEXTJOIN

Category:
Text

Summary:
Concatenates multiple text strings into a single string, inserting delimiters between each sub-string.

The TEXTJOIN function is related to the CONCAT and CONCATENATE functions, but provides the extra facility of including delimiters in the concatenated string.

Syntax:
TEXTJOIN(Delimiter, Skip Empty, String 1 [; String 2 [; … ;[ String 253]]])

Returns:
Returns a text string formed by concatenating the string arguments end-to-end, with delimiters between each sub-string.

Arguments:
Delimiter is a text string (in quotation marks), a number, a reference to a cell, a reference to a cell range, or an inline array of strings (within curly braces '{' and '}'). Delimiter specifies the text to be inserted between each pair of concatenated sub-strings.

Skip Empty specifies whether empty cells / strings are included (0 or FALSE) or ignored (any other value). If set to 0 or FALSE to include empty cells / strings, then the returned string may include adjacent delimiters.

String 1 is a text string (in quotation marks), a number, a reference to a cell, a reference to a cell range, or an inline array of strings (within curly braces '{' and '}'). String 1 specifies the first string or strings that are to be concatenated.

String 2 through to String 253 are similar to String 1 but specify the subsequent strings that are to be concatenated.


 * If Delimiter specifies multiple strings (e.g., a cell range or an inline array), the number of delimiters need not be of the same size as the number of strings to be concatenated. If there are more delimiters than strings to be concatenated, not all delimiters will be used. If there are less delimiters than strings to be concatenated, the delimiters will be re-used in a cyclic manner.
 * If Skip Empty is non-numeric, then TEXTJOIN reports a #VALUE! error.
 * When a cell range is specified, the cells are traversed row by row (from top to bottom). This applies both for the Delimiter argument and the String 1 through to String 253 arguments.
 * The length of the string to be returned is limited to be less than 256 * (1024)2 characters. If the arguments passed would cause this limit to be exceeded, TEXTJOIN reports a string overflow error (Err:513).

Additional details:
This function is not a requirement of ODF 1.2 but is compatible with the Microsoft Excel TEXTJOIN function.

Related LibreOffice functions:
CONCAT

CONCATENATE

ODF standard:
None.

Equivalent Excel functions:
TEXTJOIN