I want to sort a column alphabetically, by the last 4 numbers. Can’t see any option to do so under Data > Sort, and I’ve ran out of things to search.
How do you do an alpha sort on numbers?? Can you give us a some sample rows? Best if you edit that information into your question. Thanks.
Are the last “last 4 numbers” 4 digits occurring in texts belonging to the cells?
Are these digits assured to be the last characters?
What if there not are 4 consecutive digits?
Please give relevant examples.
Please read Guidelines for asking and edit the question then.
If you want to sort column,
foo, you could add another column with those last 4 digits by filling it with
=INT(RIGHT(foo,4)), and sort by the numbers in that new column.