Leila Gharani | How to Split Cells to Rows and Columns with TEXTSPLIT in Excel #shorts @LeilaGharani | Uploaded July 2023 | Updated October 2024, 2 hours ago.
Join 300,000+ professionals in our courses: xelplus.com/courses
Sometimes you might receive data with data all in the same cell. With Microsoft's new TEXTSPLIT function in Excel you can now split cells in rows and columns. This way you can create proper data table for further data analysis.
Requires Microsoft 365. The TEXTSPLIT function will not be available in Excel 2021 and earlier versions.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ 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
π₯ RESOURCES I recommend: xelplus.com/resources
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
Join 300,000+ professionals in our courses: xelplus.com/courses
Sometimes you might receive data with data all in the same cell. With Microsoft's new TEXTSPLIT function in Excel you can now split cells in rows and columns. This way you can create proper data table for further data analysis.
Requires Microsoft 365. The TEXTSPLIT function will not be available in Excel 2021 and earlier versions.
π My Online Excel Courses βΊ xelplus.com/courses
π¬ LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
πβ 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
π₯ RESOURCES I recommend: xelplus.com/resources
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