Leila Gharani | New Excel TEXTSPLIT Function to Separate words with Ease (includes cool tips) @LeilaGharani | Uploaded March 2022 | Updated October 2024, 8 seconds ago.
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
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.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/textsplit-file
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.
Availability of TEXTSPLIT: Available in Microsoft 365 and Excel for the web. More info in the Microsoft Excel announcement: techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066
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:
- We FINALLY Get the Excel Functions We Want: youtu.be/VWcLM6_Q_00
- NEW Excel Formula Editor: youtu.be/R7RRT5aelM0
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ 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
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
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 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
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.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/textsplit-file
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.
Availability of TEXTSPLIT: Available in Microsoft 365 and Excel for the web. More info in the Microsoft Excel announcement: techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066
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:
- We FINALLY Get the Excel Functions We Want: youtu.be/VWcLM6_Q_00
- NEW Excel Formula Editor: youtu.be/R7RRT5aelM0
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ 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
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
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
