Skip to content
ExcelExcel 2019+

TEXTJOIN function in Excel

Combines the text from multiple ranges and/or strings

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

TEXTJOIN syntax and parameters

Four arguments, three required.

  • delimiterstringRequired

    A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. If a number is supplied, it will be treated as text.

  • ignore_emptybooleanRequired

    If TRUE, ignores empty cells.

  • text1anyRequired

    Text item to be joined. A text string, or array of strings, such as a range of cells.

  • text2anyRepeating

    Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1. Each can be a text string, or array of strings, such as a range of cells.

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 Google Sheets

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 Excel gets this done.