I have a list that include at column of 2, 3, 4 and 5-digit room numbers, some of which have a letter designation at the end (ex. 1130A). I'd like to sort them so that 1130A comes between 1130 and 1131. Currently, they are sorted as "256, 133D, 15C, 203B, 77A" and I would like them sorted as "15C, 77A, 133D, 203B, 256". Thanks! I am stumped!