Sorting Issue (Mixde Fields)

[Guest]

I have an issue where I need to sort a worksheet based on a field (Bin
Location)that is sorting as seen below...

1A1
1A20
1A21
1A22
1A3
1A4

How can I get Excel to sort it the following way...

1A1
1A3
1A4
1A20
1A21
1A22

Please help.... I need to get this figured out today.
I appreciate any responses.
Thanks,
Jonathan G.

 

[Guest]

One way: add a column showing the length of the column you want to sort, then
sort using the new column then the "real" column.