Skip to main content


Splits a given text by using a specified separator and returns the part at given optional index. If the text does not contain the specified separator, the complete text is returned.The index parameter is optional. If not specified, the first part is returned. The Separator splits a text in parts. 1 returns the first part, 2 the second part, 3 the third and so on.


=SPLIT(Text, Separator, Index)


TextText to split.
SeparatorSeparator used to split text.
IndexOptional. Number which specifies the part to return. Defaults to 1.

Return Value

The part of text at specified index.


=SPLIT("cedalo/topic", "/", 2)topicReturns the second part of splitted text.
=SPLIT("cedalo/topic", "/")cedaloNo index is given so first part is returned by default.
=SPLIT("cedalo/test/topic", "/", 5)topicIndex exceeds number of parts, so return last one.
=SPLIT("cedalo/test/topic", "+", 2)cedalo/test/topicSeparator is not contained within text, so return complete text.