Syntax
=TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
Arguments
| Argument | Required | Description |
|---|
text | Required | The text to split |
col_delimiter | Required | Where to split into columns (an array gives several delimiters) |
row_delimiter | Optional | Where to split into rows |
ignore_empty | Optional | TRUE to skip empty values between consecutive delimiters |
match_mode | Optional | 0 match case (default), 1 ignore case |
pad_with | Optional | Value to fill short rows with (#N/A when left out) |
How to use TEXTSPLIT
When TEXTSPLIT returns more than one value, the result spills into the cells below and to the right. Keep those cells empty, or you get #SPILL!.
TEXTSPLIT takes 2 required arguments and 4 optional arguments. Type =TEXTSPLIT( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=TEXTSPLIT("Dakota Lennon Sanchez", " ")Result
=TEXTSPLIT("1,2;3,4", ",", ";")Result
=TEXTSPLIT("a,,b", ",", , TRUE)Result