Sorting in Microsoft Office, how to sort a column by last digits?

Question

excel

LINK
There is a file, you need to sort by the first column, not by letters, not by number, but by region, all numbers in the column.
How to do this, tell me, what kind of regular season is needed or by some key can this be done?

Answer 1

1. Insert your table into Excel
2. Add a new add. column
3. Add a formula to the new column
(you can’t just use RIGHT, because the region can consist of 1/2/3 digits, and the left side is constant: 6 characters;
"+0" is needed so that Excel eventually perceives the text, as a number - this is necessary for correct sorting)
4. Stretch the formula down
5. Sort by this add. column
If you need to remove RUS, and #VALUE, then the formula is:

=ЕСЛИОШИБКА(ЕСЛИ(ПРАВСИМВ(A2;3)="rus";ЛЕВСИМВ(ПРАВСИМВ(A2;ДЛСТР(A2)-6);ДЛСТР(A2)-6-3);ПРАВСИМВ(A2;ДЛСТР(A2)-6))+0;A2)