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
