Yes, you can use find and replace, even if your hyperlinks are underlying
other text. Just hit Alt+F9 or ToolsŕOptions, View
tab, and check Field Codes. This turns on viewing of the underlying hyperlinks.
Before viewing field codes:
After viewing field codes:
Now you can do a find and replace.
But what if you only see this and you need to change the web
Then just go to FileŕProperties
and change the hyperlink base.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.