Splitting a string in Google Spreadsheet

Here is how to split a string into tokens, then grab each token for each column in Google Spreadsheet.

So we start with the string.

Then we do =index(split(A2, " “), 1, 1). Basically, split will give us an array (or range). Then we select the first row (there is just one resulting row), and we select the first column (there are 3 resulting columns in our example).

Similarly we do =index(split(A2, " “), 1, 2) to pick the second token.

Lastly do =index(split(A2, " “), 1, 3) to pick the 3rd token.

This is similar to explode in PHP, and string split in Python. =)