Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more. Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating ...

We'll also see how well it generates new data, and finally we'll go over the key limitations of the copilot function. At the very end, I'll show you an alternative function to the copilot formula in ...