TEXTSPLIT
Description
Splits text strings into rows or columns, by specifying delimiter text that indicates where
to split the text.
Syntax
TEXTSPLIT(
text
, col_delimiter
,
[row_delimiter
], [ignore_empty
],
[match_mode
], [pad_with
])- text: The text that you want to split.
- col_delimiter: The text that marks the point where to spill the text across columns.
- row_delimiter: The text that marks the point where to spill the text down rows.
- ignore_empty: Specify TRUE to ignore empty values. Specify FALSE to create an empty cell when two delimiters are consecutive. If you don't specify an argument, the default is TRUE.
- match_mode: Determines whether the search is case-sensitive. The default is case-sensitive. Enter one of the following: 0 = Case sensitive. 1 = Case insensitive.
- pad_with: The value to pad the result with. If you don't specify the argument, the default is #N/A.