An easy way would be to highlight all your data and hit ctrl H to bring
up find and replace, place the first bit
(http://www.ntn.com/hospitality_tech/...r/site.asp?id=) in
find and then put http://players.buzztime.com/bt_site.php?s=, in
replace. This should update it.
Alternatively you could use a SS formula to find the "=" and replace
everything to the left of that with your new text
(http://players.buzztime.com/bt_site.php?s=)

Both would require a little bit of manual work still, are you looking
for an entirely automated solution?
Bob Smith wrote:

Hi folks,
I don't know much about coding macros and was hoping someone might provide
some advice. I have a workbook, with 50 or so worksheets querying 50
different URLs from one company. The company has changed their URLs from
http://www.ntn.com/hospitality_tech/...r/site.asp?id= to
http://players.buzztime.com/bt_site.php?s= .(Following each = is a different
number, like 1234 or 15923 ect.)

Is there a way to change those URLs on a global basis, and maintain the same
number following the = sign?

Thanks for any help you may be able to provide.

Regards, Bob