TEXTSPLIT function
Summary
Splits text strings by using column and row delimiters
Syntax
TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])
The TEXTSPLIT function syntax has the following arguments:
• text The text you want to split. Required.
• 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. Optional.
• ignore_empty Specify TRUE to ignore consecutive delimiters. Defaults to FALSE, which creates an empty cell. Optional.
• match_mode Specify 1 to perform a case-insensitive match. Defaults to 0, which does a case-sensitive match. Optional.
• pad_with The value with which to pad the result. The default is #N/A.
• text The text you want to split. Required.
• 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. Optional.
• ignore_empty Specify TRUE to ignore consecutive delimiters. Defaults to FALSE, which creates an empty cell. Optional.
• match_mode Specify 1 to perform a case-insensitive match. Defaults to 0, which does a case-sensitive match. Optional.
• pad_with The value with which to pad the result. The default is #N/A.
Example
=TEXTSPLIT(A2, " ")
=TEXTSPLIT(A3, " ")
=TEXTSPLIT(A2,",",";")
=TEXTSPLIT(A2,".")
=TEXTSPLIT(A2,{".","-"})
=TEXTSPLIT(A2,{".","-"},,FALSE)
=TEXTSPLIT(A2,,".")
=TEXTSPLIT(A3, " ")
=TEXTSPLIT(A2,",",";")
=TEXTSPLIT(A2,".")
=TEXTSPLIT(A2,{".","-"})
=TEXTSPLIT(A2,{".","-"},,FALSE)
=TEXTSPLIT(A2,,".")