I have a spreadsheet that refers to a bundle of web tables from a website. I
want to be able to mass replace the links on my spreadsheet so that a portion
of the web address being references gets changed

eg. Current address
http://xxx.yyy.com/Leaderboard_State...terID=4&Page=1

I want to change all references to &SeasonQuarterID=4 to &SeasonQuarterID=5

Doing this one sheet at a time is extremely time consuming. A solution would
be fantastic!

Thanks