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.
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