SPLIT

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

link - support.google.com/docs/answer/3094136 

SPLIT(Text, Delimiter)
Takes a text string consisting of two or more words and enters each word into its own cell. This simplifies sorting the data in alphabetical order.
You need to enter the character that designates where the text string should split (which is usually a blank space).
The first split-up word will appear in the cell where you enter the SPLIT function.
Additional split-up words will continue in cells along the same row to the right until all of the words appear.