use excel to strip city name from team name in NFL?
how would i go about stripping the city from a list (over 3000) of Team names.
ie Arizona Cardinals -> Cardinals
i have a spreadsheet listing all games from Sunshine Forecast for the 1978 - 2011 seasons and have a lookup so i can see the matchups between any team and i will show me the Score, winner, loser & Home/Road.
but the teams have moved/ changed names in that time.