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.
How to Split Text in Google Sheets
