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