Sorting data in column

[szvacek]

I don’t know if this is possible, but I have a column of data that is formatted “A-nn” the letters are B, D, and M. The number starts with “1” and goes up.

When sorting now, the program sorts the first number, then the second. Is there a way to sort the value numerically, e.g., 1, 2, 3, etc?

I hope that makes sense.

Thanks

[anon73440385]

Does your question mean you want M-11 to appear before A-12 because of 11 < 12 ?

[mariosv]

There is an option for that, Menu/Data/Sort - [Options] - Enable natural sort.