Split Cells in Google Sheets

How to split cells in Google Docs Spreadsheets?

Explanation

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,

Step 2: When you press Enter, data will be splitted into separate cells as shown,

To apply the split() for other cells, just select the cell and drag it to the end and release the mouse click.

Here, we have applied the split() in all the other cells from A3 to A9.

Related Topics