You need to seperate first and last names (or part names and numbers, or any other data) into separate columns. A new Excel 2013 feature called Flash Fill can help.
1. Enter the first name or other value in the columns next to your data and press Enter.
1. Enter the first name or other value in the columns next to your data and press Enter.
2. Start typing the next name. Flash fill will show the suggested names.
3. If it looks good just press Enter to accept the list.
To continue typing without using suggested name, Press Escape..