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

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

Until now, splitting words to separate cells or breaking up long text strings in Excel using a delimiter was quite a challenge. We had to use functions like LEFT, MID, RIGHT, and so on, which are not easy to use. Especially if the text has multiple spaces or different delimiters. This is over now! With the new TEXTSPLIT function in Microsoft Excel it’s so EASY now.
In addition, you can combine TEXTSPLIT with other Excel functions to do things we couldn’t do until now. For example, combine it with the TRIM function or to automatically sort the split text strings.

Availability of TEXTSPLIT: Current partly in the BETA channel for those in the OFFICE INSIDER program. More info is here available in the Microsoft Excel announcement: https://techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066

๐ŸŒ My Online Excel Courses โ–บ https://www.xelplus.com/courses/

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

โฏ† DOWNLOAD the workbook here: https://www.xelplus.com/excel-textsplit-function

๐ŸŽฌ LINKS to related videos:
– We FINALLY Get the Excel Functions We Want: https://youtu.be/VWcLM6_Q_00
– NEW Excel Formula Editor: https://youtu.be/R7RRT5aelM0

๐ŸŽ’ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

๐ŸŽ“ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

๐Ÿ“š Excel RESOURCES I Recommend: https://www.xelplus.com/resources/

๐ŸŽฅ GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

๐ŸšฉLetโ€™s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

๐Ÿ‘‰ 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

Close Menu