sorting a column

[KyaPam]

I need to sort a column of room numbers.
They sorted like this...
IC16
A1
A2
C19
C2
C6
CC1
CC10
CC2

How do I get them to sort like this?
A1
A2
B1
B2
C2
C19
CC1
CC2
CC10

 

[Airfix9]

It is possible that you had "Header Row" selected on the filter. That would account for IC16 remaining at the top (I assume that it was at the top originally.

In AlphaNumeric sorting CC10 would come between CC1 and CC2. The only way around this would be to rename the latter two to CC01 and CC02 etc. This would then sort the list properly.

Hope that helps.

 

[KyaPam]

That makes sense! What didn't I think of that?

Thanks!

 

[Airfix9]

Sometimes the simplest of answers are the hardest to find.

You're welcome.