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. =)