How do I find and replace part of a hyperlink that isn't visible?

[Dede]

I would like to use Excel 2003 Find and Replace to change all the hyperlinks
in a worksheet or workbook to point to a different pathname. For instance
part of the hyperlink path contains "iis" and I would like it to be changed
to "iis2" without changing the rest of the hyperlink.

 

[Dave Peterson]

You have one response at your first post.

I would like to use Excel 2003 Find and Replace to change all the hyperlinks
in a worksheet or workbook to point to a different pathname. For instance
part of the hyperlink path contains "iis" and I would like it to be changed
to "iis2" without changing the rest of the hyperlink.