I am sorting in MS Excel 2016. DATA:
***Column*** A
***Header*** Room
***(data)*** A16
A116
A21
A15
Sort: Sort Warning. I chose "Continue with the current selection" (not Expand the selection.") as this is just a test. Sort by Column A Sort on Values Order A to Z
***Output:***
A116
A15
A16
A21
My question is why did A116 appear first and not last?