If you have a column of multiple words (like first and last names) in Excel and you need to separate the words (first name from the last name), Text-to-columns is a quick and easy tool to use.
1) Insert a blank column after the column that has the complete name (or the multiple words) in it.
2) Select the column with the multiple words.
3) Click on the Data Ribbon.
4) Click Text-to-columns and follow the wizard using a space as your delimiter.
It really IS that easy!