Google Sheets: Text to Columns in a spreadsheet

Split Text Google Sheets

Split Up Text in a Spreadsheet

When pasting text into a spreadsheet sometimes you do not want one cell to have all of the text. The best example being when you have first and last name in the same cell.

Subscribe to the alice keeler newsletter

Data Menu

Highlight the cells that have text you wish to split up. Use the Data menu to choose “Split text to columns.”

Data Menu Split text to columns

Sample Data: Click Here

Choose Separator

After selecting “Split text to columns” notice a subtle “Separator” menu on the highlighted cells. Click on the “Detect automatically” and switch to whatever delineator or separator you choose. In the case of first and last name your delineator will be “Space.” However, comma is a common separator. Whatever symbol you want to break up your text at.


Separator is Eaten

Note that when you choose the separator, it will be “eaten.” When I have last, first my separator is … comma space. When the text is split up by the comma space both the comma and space will no longer exist and I will be left with only the last name in the the one column and first name in the next column.

comma space

One thought on “Google Sheets: Text to Columns in a spreadsheet

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.