Find/replace should work just fine for =HYPERLINK() formulas. Starting with:

=HYPERLINK("file:///s:\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9")


and replacing:
s:\
with:
x:\it\

results in:

=HYPERLINK("file:///x:\it\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9")

--
Gary''s Student - gsnu200817


"Big Mac" wrote:

I have a spreadsheet with several hyperlinks and would lile to be able to
search each hyperlink in turn and replace part of the text with another, a
sort of edit replace, (which doesn't edit the hyperlink formula)
I would like to replace s:\ with x:\it\
Ideally I would like a popup box to ask for the replace and then the with.
This would help with several other files, since we changed our folder
structure.

Also some were put in with insert hyperlink and some were put in with insert
formula hyperlink

Any advice would be extremely appreciated

Thanks