Skip to content
Google Sheets

TEXTJOIN function in Google Sheets

Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.

=TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])

TEXTJOIN syntax and parameters

Four arguments, three required.

  • delimiterstringRequired

    A string, possibly empty, or a reference to a valid string. If empty, text will be simply concatenated.

  • ignore_emptybooleanRequired

    A boolean; if TRUE, empty cells selected in the text arguments won't be included in the result.

  • text1anyRequired

    Any text item. This could be a string, or an array of strings in a range.

  • text2anyRepeating

TEXTJOIN examples

Formulas you'll actually reuse.

  1. A comma-separated list from a column, skipping blank cells:

    =TEXTJOIN(", ", TRUE, A2:A10)

    Result"Berlin, Vienna, Zurich"

  2. A multi-line address block — CHAR(10) is a line break; turn on wrap text:

    =TEXTJOIN(CHAR(10), TRUE, A2, B2, C2 & " " & D2)

TEXTJOIN in Excel

Same name — your formula ports as-is.

Try TEXTJOIN in the playground

Edit the example — nothing to install.

Preloaded with the TEXTJOIN formula from Example 1 — change anything and watch it respond.

Loading the editor…

TEXTJOIN errors

What they mean — and the fixes.

  • #VALUE!

    The joined result exceeds 32,767 characters — split the range or aggregate first.

Related functions

More ways Google Sheets gets this done.