I've noticed recently that Excel will sort my rooms not exactly in order. I'm sure it has something to do with how we label rooms in our system. Is there anything I can do to make it sort correctly? Even if I have to go in and redo the rooms? Below is a short example that has cropped up recently. The sheet was sorted by building (not shown) and room (below, smallest to largest). I have no issues with how it sorted the buildings, but as you can see it doesn't like room 103. It has sorted 103 at the top but all the sub-103's (103-a, e, g, h) were sorted below 102-Storage.
As I write this out is the hyphen what is messing it up? Is there any workarounds that can be recommended? We have some offices that are sub single offices marked 10A however if there are multiple desks in one office space we mark it as 11-A,11-B,11-C for example. So I can't just remove the hyphen unless there is a better workaround.