New Excel TEXTSPLIT Function to Separate words with Ease (includes cool tips)

Dive into the world of Excel's latest addition, the TEXTSPLIT function, which revolutionizes the way you handle text splitting, especially when dealing with multiple spaces, commas, or various delimiters.

This video is a comprehensive guide to understanding and utilizing TEXTSPLIT, showcasing its ability to simplify complex tasks that would otherwise require lengthy formulas.

Key TEXTSPLIT Features and Examples:
▪️ TEXTSPLIT Basics: Learn the fundamental use of TEXTSPLIT to split skills listed in a cell into multiple cells using simple delimiters like commas or spaces.
▪️ Handling Multiple Delimiters: Discover how to handle various delimiters within the same dataset, including commas, semicolons, and colons.
▪️ Skipping Blanks and Ignoring Unwanted Text: Understand how TEXTSPLIT can ignore empty cells or specific text (like titles) to refine the results.
▪️ Splitting Text in Rows & Columns: Explore TEXTSPLIT's ability to organize data both vertically and horizontally, transforming a single cell's data into a structured format.
▪️ Split, Sort & Stitch Back: A fascinating use case where TEXTSPLIT is combined with other functions like TRIM, SORT, and TEXTJOIN to split, sort alphabetically, and recombine data into a single cell.

00:00 How to Split Text Into Different Columns
00:38 TEXTSPLIT Basics
02:45 Ignore Empty Cells/Skipping Blanks
03:56 Split Text in Rows & Columns
04:41 Split, Sort & Stitch Back
06:54 Wrap Up

🎬 LINKS to related videos:

🚩Let’s connect on social:

This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[Tommie_Rogers]

Thanks for your simple, no-nonsense way of explaining. It's always a pleasure to watch your videos.

[MrSupernova]

Wow! How does anyone learn this stuff on their own? Even seemingly simple functions have these hidden features. I always learn so much with your channel. Cheers!

[selianboy]

ever since 1992 I have been waiting for this function! Thank you so much for demonstrating this... It used to be so tedious in the past.

[johnpoe]

Very nice. As an Excel instructor, I'm blown away by the new formauls AND how well you present topics. Thank you

[MrsCathT]

Wow, I’m speechless… the last example goes beyond my imagination!! Thank you so much Leila for sharing over and over your Excel knowledge through well explained videos. You are an inspiration!

[excel-solutions]

Amazing function. A great alternative for "text to column" functionality of Excel.
Your videos are very informative and always on point. Thank you!

[wayneedmondson]

Hi Leila. So glad to see this! Can finally retire FILTERXML/SUBSTITUTE combination to split text. And, nice to see the additional functionality built in with the optional arguments. Count me as excited about this one. Can already think of many uses. Thanks for demonstrating. Thumbs up!!

[gvinodnair]

As an Excel enthusiast, I am so happy and excited with the fact that this fantastic software is continuously evolving and paving way to unlimited possibilities when it comes to data manipulation and analysis.
MVPs like you Leila, is helping us a lot to grasp the new concepts with ease. Good job and keep it up.

[MareeTeolanafo]

Textsplit is a great function - so many possibilities when nested with other functions as you have clearly demonstrated.

[firmaevents]

My mind is blown up to pieces by this lovely function. Ms. Leila all excel users should admire you for this free informstion. 🤩🤩🤩🤩🤩🤩🤩😍😍😍😍😍😍😍😍😍

[dougidoug]

That is a really powerful function and your example and explanation on how to use it is just brilliant. Very helpful.

[growth]

Very good examples of how we can put TEXTSPLIT to use. Especially the SORT option. Thank you Leila!

[ruslansuleymanov]

The new excel functions including the “textsplit” are just awesome! Thanks for sharing, Laila!👍🏻

[zmlhcdv]

Leila Gharani
I am very grateful to you, you helped me a lot in improving my creativity and productivity at work.
Thanks from Egypt.

[billcairns]

Yes I wish I had this decades ago! You are amazing.

[thetcrew]

❤I love this. Wish I know it sooner. I always have to use text to column when I have to split name to separate columns especially those with the Dr. in front of their name. Thank you Leila for showing us this.

[stephenstone]

This video was very helpful with the splitting of a full name in one cell, then dragged the cells down to replicate the rest of the list. Saved me another good half hour of work. Thank you so much!

[marcvillalobos]

Leila, you're amazing! You showed me how to do what I was doing in a faster, cleaner way. Thanks!

[ManafKAMIL]

These videos are never boring... thank you

[randhib]

An excellent explanation. You make the math in the equation so easy to grasp.