If you have a lot of hyperlinks in your Excel document, and you need to change the URL or link text for all of them, it can be a tedious task to do manually. Fortunately, there is a way to quickly change multiple hyperlinks at once.
First, select the cells that contain the hyperlinks you want to change. Then, on the Home tab of the ribbon, in the Editing group, click Find & Select. Click Replace
In the Find what: field, type the old URL or link text that you want to replace. In the Replace with: field, type the new URL or link text. Make sure that the Look in: field is set to Formulas. Then click Replace All.
All of the selected hyperlinks will now be updated with the new URL or link text.