FUNCTION CATALOGUE / TEXT
TEXTSPLIT Excel function
Splits text using column and/or row delimiters.
Correct sentence to use
Split [text] at [delimiter].
Modify this query in PlainFormula →Example formula
=TEXTSPLIT(A2,",")
Splits text into a dynamic array.
Syntax
TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
Argument signature: text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with]
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.