Channel: Leila Gharani

Category: Education

Tags: excel tips and tricksmicrosoft excel tutorialsexcel split cell by delimiter formulaexcel for analyststextsplitmicrosoft excelxelplusvisleila gharaniadvanced excel tricksexcel 2016excel 2019xelplusmicrosoft 365excel extract text after characterexcel new formulasexcel 2013excel online coursesplit texthow to separate words in excel using formulaexcel textsplit functionexcel 365excel split text in cell

Description: 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: techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066 🌍 My Online Excel Courses ► 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: xelplus.com/excel-textsplit-function 🎬 LINKS to related videos: - We FINALLY Get the Excel Functions We Want: youtu.be/VWcLM6_Q_00 - NEW Excel Formula Editor: youtu.be/R7RRT5aelM0 🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz 📚 Excel RESOURCES I Recommend: xelplus.com/resources 🎥 GEAR I use: xelplus.com/resources/#gear More resources on my Amazon page: amazon.com/shop/leilagharani 🚩Let’s connect on social: Instagram: instagram.com/lgharani Twitter: twitter.com/leilagharani LinkedIn: 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