# TEXTSPLIT

## Content

This function splits text strings by using column and row delimiters.

>type=note
> **Note**: TEXTSPLIT is a dynamic array formula, and you need to enable the dynamic array feature in the Workbook.

## Syntax

`TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])`

## Arguments

The function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *text* | [Required] Refers to the text you want to split. |
| *col\_delimiter* | [Required] Refers to the text that marks the point where to spill the text across columns. |
| *row\_delimiter* | [Optional] Refers to the text that marks the point where to spill the text down rows. |
| *ignore\_empty* | [Optional] Specify FALSE to create an empty cell when two delimiters are consecutive. Defaults to TRUE, which creates an empty cell. |
| *match\_mode* | [Optional] Searches the text for a delimiter match. By default, a case-sensitive match is done. |
| *pad\_with* | [Optional] Refers to the value with which to pad the result. The default is #N/A. |

## Remarks

An array constant must be used if there is more than one delimiter. For example, to split by both a comma and a period, use =TEXTSPLIT(A1,{",","."}).

## Examples

![textsplit-spread-snapshot.png](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/textsplit-spread-snapshot.9b9341.png)