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)
