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.
First time here? Check out the FAQ!
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
Is there an automatic sort function in Calc? [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]
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.