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. You can also ...

The SORTBY function can be used with other functions in Excel to further refine the result. Specifically, I'll show you how to use SORTBY with FILTER to sort and filter the data in a new array at ...

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, ... Select TEXTJOIN from the Select a function: area.

Of course you need the latest build of Excel 2016 for all this to work, and at the time of writing most people don’t have Excel 2016 and even if they do they probably won’t have a build (Version ...

CONCATENATE function is available across multiple versions of Excel up to Excel 2019. However, it is being phased out in favor of CONCAT and TEXTJOIN functions introduced with Excel 2016.

Modern Excel functions like XLOOKUP, TEXTJOIN, and dynamic arrays offer faster, more versatile, and error-resistant alternatives to outdated tools such as VLOOKUP, CONCAT, and OFFSET.

Learn how to master custom sorting in Excel with SORTBY, LET, and XMATCH. ... Custom Sorting with Excel formulas : Taking SORTBY to the next level. 12:59 pm May 3, 2025 By Julian Horsey.