Assume your data in A1:A7

create a helper column
In B1: =LEFT(A1)&TEXT(MID(A1,2,99),"0000")
copy down to B7

Select both column and sort by column B. When you done, delete the helper
column



"MoKaLasco" wrote:

How do we sort Alpha Numerical in the same manner as we count?
EX: H1, H2, H9, H10, H100, H500, H1004, etc...
Excell will sort as H1, H10, H100, H1004, H2, H500, H9
Our project requires the different sorting as stated.
Any Help?