Downfall of Parsing in Google Sheets

With the start of college basketball rapidly approaching, I went through to set up my model for the new season. In doing so I checked for errors (probably the most intensive and frustrating part of writing code), and found that ESPN's schedules had changed the names of certain colleges, slightly. Every "State" is changed to "St", with the exception of a few, including Ohio State, NC State, and Iowa State. Those alterations and the rest are as follows:

Bryant University	Bryant
Boston University	Boston Univ.
Massachusetts Lowell	UMass Lowell
American University	American
St. Peter's	Saint Peter's
Florida International	Florida Int'L
St. Francis U	St. Francis (Pa)
Ohio State	Ohio State
Mount St. Mary's	Mt. St. Mary's
North Carolina State	NC State
Southern Methodist	SMU
North Carolina-Wilmington	UNC Wilmington
Cal State Northridge	Cs Northridge
Charleston	College Of Charleston
Prairie View A&M	Prairie View
USC Upstate	South Carolina Upstate
Southeast Missouri State	SE Missouri St
Illinois-Chicago	UIC
Boise State	Boise State
Mississippi Valley State	Miss Valley St
Penn State	Penn State
Southeastern Louisiana	SE Louisiana
Virginia Military	VMI
Brigham Young	BYU
Citadel	The Citadel
Cal State Fullerton	Cs Fullerton
Kent State	Kent State
Iowa State	Iowa State
Weber State	Weber State
Southern University	Southern
Texas-Arlington	UT-Arlington
Texas State	Texas State
Nebraska-Omaha	Omaha
UTSA	UT San Antonio
Tennessee-Martin	Tenn-Martin
Utah State	Utah State
Idaho State	Idaho State
Texas-Pan American	UT Pan American
Cal State Bakersfield	Csu Bakersfield
Ball State	Ball State
Louisiana-Monroe	UL Monroe
San Jose State	San José St
Louisiana-Lafayette	UL Lafayette
Mississippi Valley State	Missouri Valley

Why ESPN, why. Parsing and error checking...