Spreadsheets: How To Split Text into Different Cells

If you have a spreadsheet with a column of full names, you can split that column into separate first name and last name columns.

Firstly, add the extra column to the right of the names you want to split. This provides a column for the separated names to be added. Next, highlight the column of names you want to split. Go to the menu “Data” > “Text to Columns” & select the type of “Separator” between the words. Click OK & you’re done.