Excel TEXTSPLIT Function: Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. Sometimes, we want to split the data given in a single cell. Doing this manually is such a difficult task. So we suggest you use the TEXTSPLIT function.
If you want to know how to use Excel TEXTSPLIT Function in the worksheet, then follow the below-given steps on your spreadsheet and achieve the goal. Get an official version of MS Excel from the following link:
Definition of TEXTSPLIT Function
- It is one of the built-in functions in Microsoft Excel.
- The TEXTSPLIT function will split the text separated by a delimiter and place them in a range of cells in the spreadsheet.
- In other words, this function can split the text into rows or columns.
- Here, you will see the syntax of the TEXTSPLIT function.
- To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
- Once you enter the formula, click on the Enter button to get the result.
=TEXTSPLIT (text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
- text – The input text string to split.
- col_delimiter – The character(s) to delimit columns.
- row_delimiter – It is an optional one. The character(s) to delimit rows.
- ignore_empty – Ignore empty values. TRUE = ignore, FALSE = preserve. Default is FALSE. This is an optional one.
- match_mode – Case-sensitivity. 0 = enabled, 1 = disabled. Default is 0. It is an optional one.
- pad_with – Value to pad missing values in 2d arrays and it is an optional one.
Let’s look at some practical examples of the TEXTSPLIT Function and explore how to use it in Microsoft Excel.
- Initially, you have to open your Excel workbook on your PC and launch the worksheet with data.
- For instance, we have given the student details like name, scores, and team. We have separated these details using a delimiter comma. And we will split them into a range of cells using the TEXTSPLIT function.
- Then, you have to enter the formula in the cell as shown below to get the result.
- After entering the formula, you need to click the Enter button to get the output.
- Once you get the result of the first cell, then you can drag down that cell to fill the remaining cells.
We hope that this article helped you to know how to use Excel TEXTSPLIT function in the worksheet with a few examples. Kindly, leave your suggestions in the below comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
You can use the following video to know how to apply the TEXTSPLIT function in the worksheet.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Hi there, I’m Sridhar – an Excel enthusiast with over 10 years of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their operations and save time and money.
Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.