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.
Returns
The TEXTJOIN function returns a string/text value.
Note: This function is available in Excel 2016 only.