[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.
[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 ". [substeps] For example, if you have three columns: equal sum, variable sum and decimal sum. Add 3 together, that represents the total number of data in each column. Create a new sheet by dragging an empty cell on the left column. [title] Place data from each row in the new cell. The sum of your split columns will be the cell number. If you're using excel, you will be able to enter each cell number individually.