TEXTJOIN formula is used to join two 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. There can be up to 252 strings that are joined together.


The TEXTJOIN function returns a string/text value.

Note: This function is available in Excel 2016 only.