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

The Text-to-Columns feature ... Change U.S. format dates to UK format without formulas–or tears. ... Excel already lets you target columns in tables fairly easily, ...

Pick the column that holds the date data which are not recognized. Navigate to Data (Excel Ribbon) > Text to Columns.; Within the Text to Columns Wizard dialog box, choose the Delimited ...