New Function: SPLIT()
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.
SPLIT(text, delimiter, [orientation])
||Yes||The text or cell containing the content you want to split.|
||Yes||The character or characters to use to split the text.|
||No||How to break the text up. If you want each item to be in a separate column (default), enter
Say you have the following text you want split up:
The text is in cell
A1, and the delimiter is
To split the text with each item in a new column, use the following formula:
To split the text with each item in a new row, use the following formula: