[header] How to split cells in google docs spreadsheet [title] Enter the information you want to split. [step] In your first column, enter your data. You can quickly split entire lists of data as long as the split point is the same. 
A split point is a character that can be identified in each entry. This can be a space " ", a period ".