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. On your computer, 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 Google Sheets uses to split the data, click the dropdown menu next to "Separator."
  4. To fix how your columns spread out after you split your text, click the menu next to "Separator" and then click Detect automatically.

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

Was this article helpful?
How can we improve it?