I would like to sort data that have aplha numeric values. When I use the
sort command, the numbers wind up getting sorted by place values instead of
the actual value of the number, kind of like alphabeticaly except with
numbers
instead of letters.

For instance, I would like to these numbers sorted like this:

17A
36B
265F
1492C
1609A

Instead, Excel sorts them like this:

1492C
1609A
17A
265F
36B
It appears that the suffixed alpha characters alter the way the numbers
would normally be
sorted.

Any ideas how I can sort them more logically/numericaly?

Thanks!

Larry