TEXTSPLIT
Splits text strings by using column and row delimiters
Syntax
TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
Parameters
- text: Required. The text you want to split
- col_delimiter: Required. The character or string to use to split text across columns
- row_delimiter: Optional. The character or string to use to split text down rows
- ignore_empty: Optional. FALSE to create empty cells when delimiters are consecutive (default). TRUE to ignore
- match_mode: Optional. 0=case-sensitive (default), 1=case-insensitive
- pad_with: Optional. The value to pad with. Default is #N/A
Example
=TEXTSPLIT("Jan,Feb,Mar", ",")