TEXTJOIN Formula

TEXTJOIN formula is used to join 2 or more text together with each text separated by a delimiter.

Syntax of TEXTJOIN formula

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

Parameters Details:

delimiter : A text/character inserted between each text value in the resulting text. Most commonly, you would use a delimiter such as a comma or space character.
ignore_empty : Determines whether empty values are included in the resulting string. TRUE ignores empty values and FALSE includes empty values in the result.
text1, text2, … text_n :  The strings that you wish to join together. There can be up to 252 strings that are joined together.

Returns

The TEXTJOIN function returns a string/text value.

Note: This function is available in Excel 2016 only.