Sort within a column of cells

[GeorgeF]

A column of cells each containing First name, MI and Last name. There are no commas. How can the column be sorted alphabetically by the last names?

[mrice]

Take a copy of the column. Use text to columns on the data ribbon to split by space. Then sort by the last column.