SPLIT

Divides text around a character or string and puts each block into a separate cell in the row.

Parameter List

Syntax
SPLIT(textdelimiter
[orientation]
)
text

The text or cell containing the content you want to split. For example: "built,with,a,spreadsheet" or A1.

delimiter

The character or characters to use to split text. For example: ",".

[optional] orientation

How to display the split text. Choose either:

  • 0 (default) to split the text horizontally (one result per column)

  • 1 to split the text vertically (one result per row)

Examples

SPLIT("name,location,age", ",", 1) returns A1="name", A2="location", A3="age".