sort question

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.



Romi wrote:
>
> 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