TEXTSPLIT
Splits text strings by using column and row delimiters.
TextModern Excel FunctionsText CleaningText Processing
What it does
Splits text into an array across columns or rows.
Syntax
TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
Arguments
text(text) — Text to split.col_delimiter(text) — Delimiter.
Examples
Split CSV
Split 'A,B,C'.
FORMULA
=TEXTSPLIT("A,B,C", ",")RESULT
[A, B, C]
SAMPLE DATA
| A | |
|---|---|
| 1 | CSV |
| 2 | A,B,C |