Скачать или смотреть 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