Examples

SPLIT("John Smith", " ") produces a two-item list containing John and Smith.

SPLIT("Banana, Apricot, Grapes", ", ") produces a three-item list: Banana, Apricot, Grapes.

SPLIT(LIST("Banana", "Apricot", "Grapes"), ",") produces a three-item list: Banana, Apricot, Grapes. See also: LIST().

SPLIT(TEXT({"Banana", "Apricot", "Grapes"}), " , ") produces a three-item list: Banana, Apricot, Grapes. See also: TEXT().

Common Problems

The first argument to SPLIT() should be a textual value. If not provided a textual value, the non-textual value will be converted to Text before processing.

Of particular note, list types (List and EnumList) will be converted to Text by joining the component values with a single comma (,). For instance, the list LIST("Banana", "Apricot", "Grapes") will be processed by SPLIT() as if entered as "Banana,Apricot,Grapes".

The approach SPLIT() uses differs from how list values are converted to Text in other contexts. To get the other approach, use CONCATENATE() or TEXT() to manually convert the list to Text. For instance, CONCATENATE(LIST("Banana", "Apricot", "Grapes")) will be processed by SPLIT() as if entered as "Banana , Apricot , Grapes", with the typical space-comma-space separator.

See also: CONCATENATE(), TEXT()

Syntax

SPLIT( some-text , delimiter )

Arguments

  • some-text (any textual type): The text to be split into parts.

  • delimiter (any textual type): The delimiter between parts.

Return Value

A list of Text values: the parts of some-text that occurred around delimiter.

See Also

CONCATENATE(), EXTRACT(), FIND(), INITIALS(), LEFT(), LIST(), MID(), RIGHT(), SUBSTITUTE()

Did this answer your question?