TEXTJOIN is a Text function in Excel that joins (or concatenates) ... TEXTJOIN is only available in Excel 2019 and later. You can also use it if you use Excel for Office 365.

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.

The TEXTSPLIT() function is a new feature that is available only in Excel for Microsoft 365 and Excel for the web. If you have other editions of MS Excel, you can use the Text to Column wizard to ...