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.

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.