Using the Excel TextSplit Function to Separate Data

In this Microsoft Excel tutorial, I will teach you how to use the TextSplit function to separate data into multiple cells. Been around for almost a year now, but only for Office Insiders. It's now generally available for everyone with a Microsoft 365 subscription.

Pre-Requisite

• Excel Beginner 1: https://599cd.com/XLB1

Recommended Courses

• Text Functions in Excel Expert 1: https://599cd.com/XLX1

Learn More Excel

• There's a lot more you can do with TextSplit. If you want to see me cover more options with TextSplit, or you want to see more Excel training in general, make sure you post a comment down below.

Access Users

• I know a lot of you are Microsoft Access users, so in the next video, I'm going to show you how to use the Split function in Access VBA and, for the members, how to create a function to use Split in queries as well. Coming Soon!

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

excel 2021, excel 2016, excel 2019, excel 365, microsoft excel, ms excel, ms excel tutorial, #msexcel, #microsoftexcel, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, Excel TEXTSPLIT function, split cells, split text strings by delimiter, Best Way to Split Text in Excel