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:
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)