ExcelBanter - Sorting Issue (Mixde Fields)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sorting Issue (Mixde Fields) (https://www.excelbanter.com/excel-discussion-misc-queries/25664-sorting-issue-mixde-fields.html)

Jonathan G.

Sorting Issue (Mixde Fields)

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.

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.

"Jonathan G." wrote:

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.

All times are GMT +1. The time now is 11:12 PM.