Ask Your Question

Calc: Sort by the last 4 numbers

asked 2018-05-13 21:41:51 +0100

firewater gravatar image

updated 2018-05-14 18:01:45 +0100

LibreTraining gravatar image

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.

edit retag flag offensive close merge delete


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.

David gravatar imageDavid ( 2018-05-13 22:06:47 +0100 )edit

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 and edit the question then.

Lupp gravatar imageLupp ( 2018-05-13 22:49:00 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-05-18 00:49:29 +0100

hjek gravatar image

updated 2018-05-18 00:51:53 +0100

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-13 21:41:51 +0100

Seen: 185 times

Last updated: May 18 '18