Split Cells in Google Sheets

How to split cells in Google Docs Spreadsheets?


Data in the cells can be splitted by using the special character used in the cell. Data in the cell will be separated after the special character in successive rows.
Step 1: Type "=split(" select the cell to be splitted and type the separator to split and then ")" as given in below image,
split cells google spreadsheet
Step 2: When you press Enter, data will be splitted into separate cells as shown,
split cells google spreadsheet1
To apply the split() for other cells, just select the cell and drag it to the end and release the mouse click.
split cells google spreadsheet2
Here, we have applied the split() in all the other cells from A3 to A9.split cells google spreadsheet3

Related Topics

Google Docs Spreadsheet Tutorial