Hi I am having trouble trying to sort a group of numbers with letters. Below
are some examples of what I am trying to sort and in the correct order. The
first number represents the floor the groups are on 1, 2, or 3. Second, is
the section within that floor. So "A" would be at the front of the floor, "B"
is the section behind it, so on and so forth. The third letter is
insignificant and should not factor into the sorting. The next two numbers
represent the group within the section and the last two numbers represent the
item within the group. So... 1AW0601 would be on the first floor (1) section
"A" (A) the 6th group (06) and the first item (01). I know this is very
confusing. Any help getting these sorted would be greatly appreciated. Thanks

1AW0601
1AW0804
2CC0401
2DF0402
3BB0406
3BW1201