# Microsoft Excel Question

I’m trying to compile some teams from our area in an Excel sheet, but I would like to number-a-tize(?) them.

When I try to sort it by numbers, it puts the teams without letters at the top, then the teams with letters at the bottom. How do I do it like this?

323A
323B
323C
323Z
1001G
1001H
etc.

Thanks!

It does that because 323A isn’t actually considered a number by excel. So all non numbers are sorted after the numbers (my guess at least). You can try splitting team name into two columns. One for number and one for subteam (A-Z) if they have one. Then just sort by the number and you’ll get a decent list, though the subteams might get jumbled a bit, not sure.

Turn off list manager.

I am using Google Drive. Where is “List Manager”?

I would suggest sorting them by making decimals. I’ll use some random numbers as an example
1
2
23
64 being 64 blank
64.1 being 64 a
64.2 being 64 b
64.3 being 64 c
126

an easy way around this is to convert all numbers to 4 digit format and ensure that Excel sees the cells as containing Numbers and not General.
four digit number would be 323A to 0323A

Excel then sorts like: 0323A
0323B
0323C
0323Z
1001G
1001H
2931A
2931B
2931C

Here is a way that works. Format all teams as text. Add 0 to front of teams with only three digits and add an * to any team that doesn’t have a letter ending. E.g. team 400 would go to 0400* .
Raw => 0 + * => sorted

323A 0323A 0100*
323B 0323B 0323*
400 0400* 0323A
100 0100* 0323B
1000A 1000A 0400*
1001 1001* 1000A
323 0323* 1001*

you can use other symbols in place of * such as a - or _