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.

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

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