Dashdash functions: SPLIT()

New Function: SPLIT()

The SPLIT() function allows you to separate a text into individual elements according to a delimiter.

For example, if you have a list of animals and would like to have each animal in a separate cell, you’d use SPLIT() on the list.

Syntax

SPLIT(text, delimiter, [orientation])

Parameter Mandatory Description
text Yes The text or cell containing the content you want to split.
delimiter Yes The character or characters to use to split the text.
orientation No How to break the text up. If you want each item to be in a separate column (default), enter 0. If you want each item to be a new row, enter 1.

Examples

Say you have the following text you want split up:

split-example-text

The text is in cell A1, and the delimiter is “||”.

Example 1

To split the text with each item in a new column, use the following formula:

=SPLIT(A1, “||”)

Example 2

To split the text with each item in a new row, use the following formula:

=SPLIT(A1, “||”,1)

split-example-rows

2 Likes