As in Excel, sort alphabetically not by the first word and the second?

As in Excel, sort alphabetically not by the first word and the second?
For example the column looks like this:

Ewheni Nikolaev
Andvan Grachev
Nadida Ivanova
Necoli Nikolaev
PETR Grachev
....

Here it is necessary to sort was this:
Ivan GRachev
Peter GRachev
Hope AndANOVA
Eugene Nikolaev
Nicholas Nikolaev
March 19th 20 at 09:00
1 answer
March 19th 20 at 09:02
Solution
* Copy column a to B
* Divide it into two (B and C) space-delimited
* Sort an entire table in the C
* (optional) Hide B and C
Thank you, and can not immediately without separation to do? - clifton_Rolfson commented on March 19th 20 at 09:05
@clifton_Rolfson, In Excel - no - yasmeen commented on March 19th 20 at 09:08
More complete answer - in fact, the name should be stored in different stoamch. Then they can be manipulated.
So right from razdelit on A and B and quietly sort and filter. - yasmeen commented on March 19th 20 at 09:11

Find more questions by tags Excel