Mastering Excel's TEXTSPLIT function: Separating data into columns & rows, with optional parameters
In this comprehensive Excel tutorial, you'll learn how to leverage the powerful TEXTSPLIT function to efficiently separate your data into columns, rows, and even both simultaneously, surpassing the limitations of the traditional TEXT TO COLUMNS method. We'll dive into the intricacies of the TEXTSPLIT function, exploring its optional parameters and demonstrating a practical example to enhance your data manipulation skills. Don't miss out on this opportunity to optimize your Excel workflow and take control of your data organisation. Join us now and become an Excel pro!
0:00 Introduction
0:41 Basics of TEXTSPLIT
1:29 Using multiple delimiters
2:00 Using TEXTSPLIT to split into rows
2:28 Splitting into both rows and columns
3:08 Other parameters in TEXTSPLIT - empty, case sensitive and pad
3:33 Example of padding data
4:06 Final comments
Want to watch our previous video on TEXTJOIN, you can find it here: • Video
Join our free online Excel for beginners tutorials and playlists, and master Microsoft Excel. From zero to Excel hero, our tutorials cover everything you need to know!
Share your desired Microsoft Excel tips and tricks for future videos. We'll continue to provide tutorials on Excel basics for beginners and develop a comprehensive collection of free Microsoft Excel course materials. Stay tuned for more! :-)
Check out our playlist on inputting, viewing and managing data: • FREE Excel course for beginners: Week 3 - ...
Or check out the following videos:
Information on TEXTJOIN and CONCAT
You'll find information on CONCATENATE in my formulas and operators video: • FORMULAS and OPERATORS: Learn the basics o...
Drop down lists: • Excel Basics: EXCEL DROP DOWN LIST - a 'ho...
UNIQUE function: • Video
XLOOKUP: • What is XLOOKUP and why is it a good alter...
Named ranges: • Naming data in excel and how to use in for...
Using named ranges and XLOOKUP together: • XLOOKUP & Named Ranges: use them together ...
Filter with multiple criteria: • FILTER function. How to use it with multip...