How to use the TEXTSPLIT Function - A Complete Guide

We have been using “Text To Columns” for decades. When “Flash Fill” was announced in 2013, it was a game changer in Excel. Both tools are static and do not update when input changes. If you are looking for a dynamic solution, the TEXTSPLIT function introduced in 2022, is here to help. In this tutorial I show you how to use the TEXTSPLIT function to split a text string into columns or rows, even if you have multiple delimiters. What if there is No delimiter? How to have the function spill in 2 directions, or filter the source text? Can we use it for fixing date problems? This is a complete guide for using the TEXTSPLIT function like a pro. You can Download the exercise file and follow along, by clicking on the link: https://officeinstructor.com/public/ Book a Corporate Training for your employees and check our course catalog: www.OfficeInstructor.com