Calc: Sort by the last 4 numbers
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.
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.
Asked: 2018-05-13 21:41:51 +0100
Seen: 185 times
Last updated: May 18 '18
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
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 https://ask.libreoffice.org/en/questi... and edit the question then.