Splitting Text to Columns

You will learn how to use the tool to split data from one cell into multiple columns based on a chosen delimiter, such as a comma, space, or custom symbol. This is useful when working with data that contains lists or long strings that need to be structured.

Suppose you have the string John Doe, 123 Main St, New York in cell A1. Using the Split Text to Columns tool, you can easily split this string into several columns: first name, address, and city.

1. Select the cell or range of cells that contains the text you want to split.
2. Go to the Data → Split text to columns menu;
3. In the menu that appears, choose a delimiter. By default, Google Sheets will automatically detect the delimiter, but you can choose one manually: