How to Split Text into Columns in Google Sheets

Select the Column to Split

Highlight the column containing the data you want to split.

Use the Split Feature

Go to Data > Split text to columns. Google Sheets automatically detects the separator.

💡 You can manually select a separator from the dropdown that appears.

Choose a Separator

Select Comma, Semicolon, Period, Space, or Custom. For phone numbers like "555-1234", choose Custom and enter the dash (-).

Use SPLIT Formula

Use =SPLIT(A1, ",") to split the contents of A1 by comma into separate cells. This method is dynamic and updates when source data changes.