The TEXTJOIN formula may not be working on your system if you’re having a version of Excel that doesn’t support this formula. TEXTJOIN is only available in Excel 2019 and later.

If you have Excel 2019 or Excel 365, you can use the function TEXTJOIN to quickly join text in one cell and separate the text with any delimiter, even if you have many rows or columns of data to join.

In this guide, we’ll explore five innovative Excel formulas: CHOOSECOLS, TEXTSPLIT, TEXTJOIN, REGEX, and GROUPBY, along with AI-powered functions and the versatile DATEDIF function.