sort question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top