Ask Your Question
0

How to sort in alphabetical order in Calc?

asked 2015-01-13 20:16:54 +0200

Bill.Aska gravatar image

I'd like to sort data based on an alphanumeric code, but since it contains also numbers it seems to always sort them in numerical order. The result I need should i.e. look like this:

1
2
21
243
35
6
9
A5
B66
B679
...

How can I achieve this? Setting cell formatting category to text doesn't seem to work.

edit retag flag offensive close merge delete

Comments

"When you need to modify the sort order of a data set, the most flexible and powerful way to do it is to add a column that contains a sort key computed from the data that you need to sort. Because you compute the sort key, you can produce (almost) any order you want." (c) Joe Smith aka acknak In your case, probably the formula is quite similar to =TEXT(A2;"@")

JohnSUN gravatar imageJohnSUN ( 2015-01-13 21:19:28 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2016-05-02 19:12:28 +0200

erAck gravatar image

Under Data -> Sort ->Options check "Enable natural sort".

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-01-13 20:16:54 +0200

Seen: 3,329 times

Last updated: May 02 '16