Search
Clear search
Close search
Google apps
Main menu

Separate cell text into columns

You can split delimited data, such as text separated by a comma, into several columns with Google Sheets. For example, a column with "Last name, First name" can be split into 2 columns: "Last name" and "First name."

Split data into columns

Data isn't in a spreadsheet yet
  1. Open a spreadsheet in Google Sheets.
  2. Paste the data you want to split into columns.
  3. In the bottom right corner of your data, click Paste Paste.
  4. Click Split text to columns. Your data will split into different columns.
  5. To change the delimiter, in the separator box, click Comma.
Data is already in a spreadsheet
  1. Select the data you want to split into columns.
  2. At the top of the screen, click Data > Split text to columns. Your data will split into different columns.
  3. To change the delimiter, in the separator box, click Comma.

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?