Hi,

I have one column called 'ID'. ID is like A1, A2...B10, B11.... each ID has
one alphabet + number(s).
When I sort this column, I end up data sorted like...A1, A10, A11....A2,
A21, A23....A3, A31....B1, B11.... I have to manually move data around
because I want see them as A1, A2....A10, A11...A20, A21...B1, B2...B10,
B11....

What should I do? Please help. Thank you.