TEXTSPLIT Function

The TEXTSPLIT function is one of the text and data functions. It is used to split text strings through column and row delimiters.

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

The TEXTSPLIT function syntax is:

TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])

where

text is used to set the text you want to split.

col_delimiter is an optional argument. It is used to set the text that marks the point where to split the text across columns.

row_delimiter is an optional argument. It is used to set the text that marks the point where to split the text down rows.

ignore_empty is an optional argument. It is used to specify FALSE to create an empty cell when two delimiters are consecutive. Defaults to TRUE, which creates an empty cell.

match_mode is an optional argument. It is used to search the text for a delimiter match. By default, a case-sensitive match is done.

pad_with is used to set the value with which to pad the result. Defaults to #N/A.

To apply the TEXTSPLIT function,

1. select the cell where you wish to display the result,
2. click the Insert function
   icon situated at the top toolbar,
   or right-click within a selected cell and select the Insert Function option from the menu,
   or click the
   icon situated at the formula bar,
3. select the Text and data function group from the list,
4. click the TEXTSPLIT function,
5. enter the required arguments separating them by commas,
6. press the Enter button.

The result will be displayed in the selected cell.

Alla pagina precedente