split

1. Syntax:

Return Range  split(String str, String separator)

Description:

Splits str into a row of values separated by separtor and places it at the current cell.

2. Syntax:

Return Range  split(String str, String separator, Identifier mode)

Description:

Splits str into a column of values separated by separtor and places it at the current cell.

Options:

Identifier mode:

Examples:

($b1:$b5) = split($a, ",")
Before:
AB CD
11,234,567
2My Name is Alex
3Hello, World
434,,56
5,comma,
616
After:
AB CD
11,234,5671234567
2My Name is AlexMy Name is Alex
3Hello, WorldHelloWorld
434,,563456
5,comma,comma
616
($a2:$f2) = split($1, " ", reverse)