Try this

Col A u have data ,
in col B put this formula =right(A1,1) and drag it till u have the
data
in col C put this formula =left(A1,2) and drag it till u have the data

and then go to data | sort | sort by : col B , then by : col C | ok





On Sep 23, 1:21*pm, Mac wrote:
Can anyone help me with this problem. *I am looking to sort warehouse
locations by level and row. *The locations are as follows: *210064C. *The
breakdown on this is the 21 is the row, the 006 is the column, the 4 is the
level and the letter is the placement of merchandise in that location. *Below
I have added sample locations that I would like to set by row and level. * *
Thanks in Advance, *Mac

210222A *
210222B *
210222C *
210223A *
210223B *
210223C *
210224A *
210224B *
210224C *
210225B *
210225C *
210245B *
220031A *
220031B *
220031C *
220031C *
220031C *
220032B *
220032C *
220033B *
220034A *
220035A *
220035B *
220035C *