How to sort alphabetically in Excel not by the first word, but by the second?

Question

excel

How to sort alphabetically in Excel not by the first word, but by the second?
For example, the column looks like this:
E vgeny Nikolaev
I van Grachev
N adezhda Ivanova
N ikolai Nikolaev
P etr Grachev
....
Here it is necessary that the sorting be as follows :
Ivan G rachev
Petr Grachev Nadezhda I vanova Evgeniy N ikolaev Nikolay N ikolaev

Answer 1

* Copy column A to B
* Split it into two (B and C) by space delimiter
* Sort the entire table by C
* (optional) Hide B and C