I’ve definitely had times where I wanted to sort by the last name, but the names were all in one cell, with the first names first. Excel can deal with this SO FAST.

You have your sheet with the names and the occupations. In the column next to existing data (you can’t have a blank column in there, it breaks it) You write the first name of the first person, and in the next column the last name of the first person. Then you “Flash Fill”

Done!

	New Column “First Name” & New Column “Last Name” (right next to existing data).
	Write in the first name of the first person in the top cell.
	Click the cell below the first name, and select “Fill → Flash Fill”
	Do the same for the last name!