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 _
This worked with my excel… not sure about google.
Alright, thank you all for your help!