TEXTJOIN

Summary

The TEXTJOIN function joins text strings from multiple cells or ranges and separates the combined values with any delimiter that you specify. It can either ignore or include empty cells in the result.

The Excel Syntax:

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

Delimiter [required] – is a separator between each text value that you combine that shows in the resulting formula. Usually, it is supplied as a text string enclosed in double quotes (such as comma or space) or a reference to a cell containing a text string. A number supplied as a delimiter is treated as text.
Ignore_empty [required] – Determines whether to ignore empty cells or not:
- TRUE – ignore any blank cells.
- FALSE – include empty cells in the resulting string.
Text1 (required) – first value to join. Can be supplied as a text string, a reference to a cell containing a string, or array of strings such as a range of cells.
- Alternatively, this can be a range, such as A2:A45
Text2, … (optional) – additional text values to be joined together. A maximum of 252 text arguments are allowed, including text1.

TEXTJOIN is a newer Excel function found in Excel 2019 and Excel 365 that greatly enhances the function over the older CONCAT and related functions.
Any numbers referenced in the function are converted to text