top of page

TEXTJOIN

Join contents of two or more cell

The TEXTJOIN function is also a text combining function available in Excel 2016. This can be easily used to include a delimiter between text strings and this delimiter can even be an empty string. This function is also capable of ignoring empty cells in a given range.

Syntax

Related

&

CONCAT

CHAR(10)

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

* Excel 2016

Note

  • The delimiter lets you specify any character for separating your text. This may be a comma, space, ampersand, or anything you like. The characters must be enclosed by double quotes, or a reference to a valid text string. Any numbers will be regarded as text.

  • Ignore_empty is a required argument. If it's TRUE, empty cells will be ignored. You can include blank cells by setting this value to FALSE.

  • text1 lets you specify a range of cell values to concatenate rather than having to enter each one.

  • [text2, …] is an optional argument that allows specifying further ranges to include in if your range is not continuous.

  • There can be a maximum of 252 arguments for the text items. If the resulting string exceeds the cell limit of 32767 characters, the TEXTJOIN function returns the #VALUE! error.

bottom of page