I had used Excel for years before I stumbled across most of these features. Like many people, I thought I had the application pretty well mastered—shortcuts, formulas, filters, even pivot tables, not ...
Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more. VBA sub procedures can perform lots of tasks and there are many ways to execute those ...