Thanks Jack. After looking at what you recommended I did a little more
research and found an easier way:
If what you want to sort by is in column a, put
=IF(ISERROR(A1*1),LEFT(A1,LEN(A1)-1),A1&"" IN column b and drag it down to
fill all cells that are filled in A. Then sort by row B then A.
Thanks for all your help!

"Jack Sons" wrote:

agc1234,

Also look at post "sorting alphanumeric" by Chronos 17-05-2005 09.01 and
especially Héctor Miguel's asnwer.

Jack Sons
The Netherlands

"agc1234" schreef in bericht
...
Help!
I am using Excel 2000. I have a spreadsheet with multiple columns and the
column that I want to sort by contains sheet numbers. I know how to sort
by
that row, the problem is that when I do, instead of sorting 1, 1A, 2, 2A,
3,
4, 4A, 4B . . . Excel sorts it as: 1, 2, 3, 4, 1A, 2A, 4A, 4B. I have
tried
making the numbers all text and all numbers. Neither works. I have also
tried both options that you get when you are sorting (the screen that pops
up
with two sorting options). None have worked so far!!! Please help!!!