Excel: TEXTJOIN Function

TEXTJOIN 

This function in Excel concatenates multiple values together with or without a delimiter. TEXTJOIN can concatenate values provided as cell references, ranges, or constants, and can optionally ignore empty cells. IT takes three required arguments: delimiter, ignore_empty, and text1.

Delimiter is the text to use between values that are concatenated together and should be enclosed in double-quotes (""), for example, a space (" "),  or a comma with a space (", "). To use no delimiter, supply an empty string (""). 

Ignore_empty is a Boolean (TRUE/FALSE) value that controls whether empty values should be ignored or added to the result. This is often set to TRUE to avoid delimiters with no content in the result from TEXTJOIN.

Text1 is the first value to join together. This can be a cell reference, a range, or a hard-coded text value. Subsequent optional arguments, text2, text3, text4, etc. can be provided up to 252 values total.

TEXTJOIN is set up to concatenate names. Notice the cell reference for Title is provided first, followed by a range for First, Middle, and Last. Ignore empty is set to 1 (TRUE) to avoid adding extra space to names without Middle or Title values.

Arguments of TEXTJOIN Function:

• delimiter - Separator between each text.
• ignore_empty - Whether to ignore empty cells or not.
• text1 - First text value or range.
• text2 - [optional] Second text value or range.