Splits text strings by using column and row delimiters.
The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows.Â
=TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])
-
 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 FALSE to create an empty cell when two delimiters are consecutive. Defaults to TRUE, which creates an empty cell. Optional.
-
match_mode   Searches the text for a delimiter match. By default, a case-sensitive match is done. Optional.
-
pad_with       The value with which to pad the result. The default is #N/A.
Example: Split a name and a sentence by using a common delimiter.
=TEXTSPLIT(A2," ")
Splits the a cell (A2) into separate words in subsequent columns. "Adele Vance Esq" becomes "Adele"Â "Vance" "Esq" in cells A2, B2, and C2.Â
For more info and examples, see TEXTSPLIT function.
Splits text strings by using column and row delimiters.
The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows.Â
=TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])
-
 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 FALSE to create an empty cell when two delimiters are consecutive. Defaults to TRUE, which creates an empty cell. Optional.
-
match_mode   Searches the text for a delimiter match. By default, a case-sensitive match is done. Optional.
-
pad_with       The value with which to pad the result. The default is #N/A.
Example: Split a name and a sentence by using a common delimiter.
=TEXTSPLIT(A2," ")
Splits the a cell (A2) into separate words in subsequent columns. "Adele Vance Esq" becomes "Adele"Â "Vance" "Esq" in cells A2, B2, and C2.Â
For more info and examples, see TEXTSPLIT function.
Splits text strings by using column and row delimiters.
The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows.Â
=TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])
-
 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 FALSE to create an empty cell when two delimiters are consecutive. Defaults to TRUE, which creates an empty cell. Optional.
-
match_mode   Searches the text for a delimiter match. By default, a case-sensitive match is done. Optional.
-
pad_with       The value with which to pad the result. The default is #N/A.
Example: Split a name and a sentence by using a common delimiter.
=TEXTSPLIT(A2," ")
Splits the a cell (A2) into separate words in subsequent columns. "Adele Vance Esq" becomes "Adele"Â "Vance" "Esq" in cells A2, B2, and C2.Â
For more info and examples, see TEXTSPLIT function.
