The TEXTJOIN function works with Excel 2019 and Office 365.
The TEXTJOIN Excel function is used to join two or more text values with a specific delimiter and have it return the concatenated text string with that specified delimiter. You can use it to combine names; to concatenate a range; or to concatenate individual cells and ranges inside the function. It's different from the CONCAT function because the delimiters have to be entered every time in between two strings.
SYNTAX AND ARGUMENTS
This is the syntax: TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...text_n])
The delimiter is a string or character separating each text value in the concatenated string, such as a comma, space, hyphen, or phrase. You have to insert it inside double-quotes; for example, if you wanted to join text in cells A2 and B2 with a comma, you would use TEXTJOIN(“,”,TRUE,A2,B2). If you didn't want to use a delimiter, you would add a double quote with no space: “”.
Set ignore_empty to TRUE if you want to ignore empty cells when you join the text, or set it to FALSE if you want to include the empty cells in the concatenations. You can use ‘1’ or ‘0’ instead of TRUE or FALSE.
text1, text2, ….. text_n is a list of all the cells containing the text strings you want to join. The maximum number that can be joined is 252.
How to Keep Source Formatting
If you use the function to concatenate dates or other special formats, Excel will either give a #VALUE error or strip the formatting before performing the function, so you'll need to convert any special formats to text strings with the TEXT function first: TEXT( B2, “mm/dd/yy”).
TEXTJOIN works with Excel 2019 and Office 365.