Sorting Issue (Mixde Fields)

J

Jonathan G.

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.
 
P

PegL

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.
 
Top