Splitting Text In Excel Using The TEXTSPLIT Function | Office 365
👇 LET'S CONNECT 👇
https://linktr.ee/excelupnorth
—————————————————————
⏰ Timestamps ⏰
00:00 Intro
00:15 Overview
01:07 Using #textsplit
03:03 Handling Errors
04:42 Case Sensitivity
06:07 Outro
—————————————————————
The TEXTSPLIT function in #excel is an incredibly powerful tool for breaking down complex data into an easy-to-read format. In this video, we’ll walk through a practical example using an inventory spreadsheet, where we have categories of wood, the types of wood with their quantities, and dimensions stored in a single table. The goal is to dynamically extract, split and organize this information so that each type of wood appears in its own row with the corresponding quantity and dimensions in separate columns. We’ll build up the TEXTSPLIT function step by step, carefully going through each argument.
As we work through this example, we’ll tackle real-world challenges like handling multiple delimiters, ignoring empty cells, and using the match_mode argument to differentiate between uppercase and lowercase text. Plus, we’ll make the formula fully dynamic by incorporating XLOOKUP, allowing us to switch between different wood categories with ease. By the end of the video, you’ll have a solid understanding of how to use TEXTSPLIT in your own #dataanalysis to clean and structure data efficiently.