sort question

[Guest]

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.

 

[Dave Peterson]

I'd insert a couple of columns adjacent to that ID column.

Then do data|Text to columns
(fixed width)
and separate the single letter into its own column (and the numeric portion into
its own).

Then use those two columns to sort by.