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

  1. Open a spreadsheet in Google Sheets.
    • If the data’s already in the sheet, select the cells you want to split.
    • If the data isn’t in the sheet yet, paste it.
  2. At the top, click Data and then Split text to columns.
  3. Optional: To change what character Sheets uses to split the data, click Comma.

Note: After pasting data, you can click Paste Paste and then Split text to columns.

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

Was this article helpful?
How can we improve it?