I have multiple lists of part numbers, both numeric and alpha numeric in varying digit numbers and wish to sort them.

Is it not possible to sort a column based on reading the cell from left to right? ie:001, 111, 2, 22-33, 3, etc.

I have lists that were sorted this way but trace how.

Rgds