Skip to content

How to Use Excel TEXTSPLIT Function?


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:

Excel TEXTSPLIT FunctionPin
Excel TEXTSPLIT Function

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])

Argument Explanation:

  • 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.
Input ValuesPin
Input Values
  • Then, you have to enter the formula in the cell as shown below to get the result.
Enter the formulaPin
Enter the formula
  • 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

Video Tutorial

You can use the following video to know how to apply the TEXTSPLIT function in the worksheet.

Read Ahead:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...