Luckily, Excel is one step ahead of us morons, making it easy to split a column full of names into two separate columns with first and last names. You’ve got yourself a spreadsheet full of people’s names and some idiot has failed to format the spreadsheet columns into first and surname, making it impossible to sort by surname.