SPLIT

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.

Syntax

=SPLIT(Text, Separator, [Index])

Arguments

Name	Type	Description
Text	String	Text to split.
Separator	String	Separator used to split text.
Index (optional)	Number	Number which specifies the part to return. Default value: 1

Return

Type	Description
String	The part of text at specified index.

Examples

Formula	Result	Comment
=SPLIT("cedalo/topic", "/", 2)	topic	Returns the second part of split text.
=SPLIT("cedalo/topic", "/")	cedalo	No index is given so first part is returned by default.
=SPLIT("cedalo/test/topic", "/", 5)	topic	Index exceeds number of parts, so return last one.
=SPLIT("cedalo/test/topic", "+", 2)	cedalo/test/topic	Separator is not contained within text, so return complete Text.