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

For example the column looks like this:

**E**wheni Nikolaev

**And**van Grachev

**N**adida Ivanova

**N**ecoli Nikolaev

**P**ETR Grachev

....

Here it is necessary to sort was this:

Ivan**G**Rachev

Peter**G**Rachev

Hope**And**ANOVA

Eugene**N**ikolaev

Nicholas**N**ikolaev

For example the column looks like this:

....

Here it is necessary to sort was this:

Ivan

Peter

Hope

Eugene

Nicholas

asked March 19th 20 at 09:00

1 answer

answered on

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

* Divide it into two (B and C) space-delimited

* Sort an entire table in the C

* (optional) Hide B and C

Find more questions by tags Excel

So right from razdelit on A and B and quietly sort and filter. - yasmeen commented on March 19th 20 at 09:11