⚠️ Prior to version 7.0.282, the function is named TEXTSPLIT. Velixo renamed this function to VXTEXTSPLIT to avoid conflicts with the upcoming built-in TEXTSPLIT function from Microsoft, which has a different set of parameters.
Description
The VXTEXTSPLIT 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
VXTEXTSPLIT(Text [or cell reference], delimiter])
The VXTEXTSPLIT 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
=VXTEXTSPLIT(D7,";")
Cell D7 contains a list separated by semicolons (and includes a blank value).
Results:
Example #2
=VXTEXTSPLIT("abc;xyz;123;890",";")Description: Returns the segments abc, xyz, 123, and 890 as elements of a dynamic array.
Result:
