ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I find and replace part of a hyperlink that isn't visible? (https://www.excelbanter.com/excel-discussion-misc-queries/23865-how-do-i-find-replace-part-hyperlink-isnt-visible.html)

Dede

How do I find and replace part of a hyperlink that isn't visible?
 
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.

Dede wrote:

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


All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com