Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/01/Sort-full-names-by-last-name.xlsx

Download the Power Query add-in https://www.microsoft.com/en-gb/download/details.aspx?id=39379

In this video I demonstrate 5 methods for sorting names where the full name is in a single cell and you want to sort by the last name in the cell (right-most name). This also translates into being able to sort by the last word in cell.

The methods I demonstrate (in order) are:
1) Flash Fill
2) Find and replace
3) Text to columns
4) Power Query
5) Formula, using the SUBSTITUTE, LEN, FIND and MID functions.
=MID(E3,FIND("^",SUBSTITUTE(E3," ","^",LEN(E3)-LEN(SUBSTITUTE(E3," ",""))))+1,LEN(E3))

This video will answer the following queries:
Sort Full Name by Last Name in Excel
Excel sort by last word in cell
Custom sort by last name in Excel
How to sort by last name in Excel when the first is first
How to separate first and last name in Excel
What is the formula to separate first and last name in Excel?
How do you separate names in Excel?
------------------------