sort non delimeted non fixed width alpha numeric column

[jwbuyer]

I have sku inventory id numbers that I need to sort as follows:
1350
1350J
1350T
2500
2500J
2500T
12500
12500J
12500T
Excel sorts this way of course:
1350
2500
12500
1350J
1350T
2500J
2500T
12500J
12500T

the number of characters varies between 3 and 5 numeric characters, then a
one letter alphabetical character.

I am using Excel 2003

Please help

 

[Mike H]

Hi,

You need a helper column. With your data in column A put this in b1 and drag
down

=LOOKUP(10^23,--LEFT(A1,ROW(INDIRECT("1:"&LEN(A1)))))

Sort the 2 columns by this column which you can then hide or delete.

Mike

 

[jwbuyer]

Thanks, worked like a charm!

Hi,

You need a helper column. With your data in column A put this in b1 and drag
down

=LOOKUP(10^23,--LEFT(A1,ROW(INDIRECT("1:"&LEN(A1)))))

Sort the 2 columns by this column which you can then hide or delete.

Mike