TEXTSPLIT Function Explained
The TEXTSPLIT function in Microsoft Excel splits a text string into multiple parts based on a delimiter. It takes two arguments: the text string to be split and the delimiter. It returns an array of strings, each of which is a substring of the original text string, separated by the delimiter.
TEXTSPLIT Function Syntax
TEXTSPLIT(text, delimiter)
- text: The text string to be split.
- delimiter: The character or characters used to separate the text string into parts.