Calc 24.2.5.2 Sorting alphanumeric in column

[sswcharlie]

Hi
Would like to be able to sort an alphanumerical list:

Macro to sort data (named range) in ascending order. Alphanumeric. Eg. 5, 41, 41A, 3, 3A, 2.
Order required: 2, ,3, 3A, 5, 41, 42A.

Is there a method available for this type of sort. Have enabled natural sort.

Would it be easier to sort by numerals 2 digit with point between main and sub number.(no alpha).

eg use 2, 3, 3.1, 5, 41, 42.1
Charles

[EarnestAl]

@sswcharlie

5, 41, 41A, 3, 3A, 2

If you want to use the numbers as numbers then it would be better to use 41.1 rather than 41A.

To use your existing data (street numbers?), select the column and click Format > Cells > Numbers > Text. If all the data is text then natural sort will give the result you want, otherwise it will sort numbers before text.

[sswcharlie]

Good advice. Thanks. Done that now and way better and cleaner.

Charles