Google Sheets is smart enough to recognize the space between first and last names and create two columns. Open a spreadsheet in Google Sheets. Select the data you want to split.

Here are six tips to turn you into a spreadsheet pro whether you're using Microsoft Excel or Google Sheets. Alphabetize your data You can customize your spreadsheet data a number of ways ...