Joins a number of values together, separating them with a delimiter, and returns the resulting text string. TEXTJOIN (", ", FALSE, "a", "b", "c") TEXTJOIN (", "; FALSE; "a"; "b"; "c") returns "a, b, c".

The second parameter determines if blank values and empty text strings should be part of the returned text string. The remaining parameters are the values that should be joined together. Use any combination of regular values and arrays of values.

Converting numbers to text strings

If a number is given as a parameter, it is converted to a text string:

This formula returns a value such as "1234.56 — 9876.54", using the decimal separator of the configured locale. If that locale is German, for instance, "1234,56 — 9876,54" is returned instead. Thousands separators are not used.

Determining how numbers are converted to text

To get a formatted value where you determine how the numbers are formatted, use any of these functions:

• FIXED
• FORMAT
• FORMAT.PERCENTAGE
• FORMAT.FRACTION
• FORMAT.SCIENTIFIC

Colors, logical values and blank values

Colors are converted to CSS color values, such as "#00ff00ff" for green with no transparency. The logical value FALSE is converted to "FALSE" and TRUE is converted to "TRUE". Blank values (including those produced by the BLANK function) are converted to "" .

TEXTJOIN and arrays

The values to join together can be arrays, and even arrays of arrays. All their elements are joined together. This formula returns "a, b, c, d":

If the delimiter is an array, TEXTJOIN is invoked once per delimiter and the results are collected as an array. This formula returns the array { "a, b, c", "a; b; c" }{ "a, b, c"; "a; b; c" }:

Unlike some spreadsheets, TEXTJOIN does not cycle through an array of delimiters, using a different delimiter between each pair of values.