Often, you need to split the content of a cell in your spreadsheet that is separated by a comma or space, such as the first and last names of a contact. Luckily, Google Sheets provides a simple, straightforward approach to dealing with merged datasets.
How to Split Text in Google Sheets
Fire up your browser, open up a Google Sheets document, and select all the cells you want to split up.
Warning: Make sure the cells to the right don’t already have data in them. This feature overwrites those cells without any warning.
Next, click Data > Split Text Into Columns.
Sheets has a few common options to choose from when you split up data in your document, such as by comma, semicolon, full stop, and space. For this example, we’ll use “Space” as a separator, since there is a space between our datasets.