How To Split Cells In Google Sheets?

Select the cell or range of cells you want to split

Go to the Data menu

Click Split text to columns

Choose the separator type from the dropdown

Use Custom if you want to enter a specific delimiter

If needed, use formulas like SPLIT() to split cell contents into separate cells

For splitting data into rows, use functions like SPLIT() with TRANSPOSE() or other array formulas