Description
The TEXTSPLIT function takes a delimited list (values separated by a common character) and separates the values in that list into an array of rows.
Examples include a list of comma-separated values: 1,2,3,4,5
Syntax
TEXTSPLIT(Text [or cell reference], delimiter]) The TEXTSPLIT function uses the following parameters:
Parameter | Required/Optional | Description |
Text | Required | The delimited text to be separated (may be typed into the function or be in a separate cell). |
Delimiter | Required | The character that is used - in the Text - to separate the values. |
Examples
Example #1
=TEXTSPLIT(D7,";")Cell D7 contains a list separated by semicolons (and includes a blank value).
Results:
Example #2
=TEXTSPLIT("abc;xyz;123;890",";")Description: Returns the segments abc, xyz, 123, and 890 as elements of a dynamic array.
Result:
