SPLIT()

List from text

Returns a list of text values divided around a specified delimiter.

Note: The delimiter is case-sensitive.

Sample usage

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(text, delimiter)

  • text - Any textual type that will be split into parts.
  • delimiter - Any textual type that specifies the delimiter between parts.

See also

CONCATENATE()

EXTRACT()

FIND()

INITIALS()

LEFT()

LIST()

MID()

RIGHT()

SUBSTITUTE()

Was this helpful?
How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
false
false