⚠️ 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.
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
VXTEXTSPLIT(Text [or cell reference], delimiter])
The VXTEXTSPLIT function uses the following parameters:
The delimited text to be separated (may be typed into the function or be in a separate cell).
The character that is used - in the Text - to separate the values.
Cell D7 contains a list separated by semicolons (and includes a blank value).
Description: Returns the segments abc, xyz, 123, and 890 as elements of a dynamic array.