Text to column question

In the attached file I want to take the raw data (college basketball standings) and display the team record as a win-loss format rather than a date using text to colums without retyping the result. I have tried formating as text but the format disapears using text to colums.

The file should explain it much clearer.

Jim O