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.

Learn how to master dense ranking in Excel to fix ranking gaps and improve data analysis with this step-by-step guide. Fix Excel ranking by ...

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.