Examples

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

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

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?