Why don't you do a find and replace.

Replace it with something like this:

=HYPERLINK("file:///E:\My
Documents\Travel\2005\Data\12345.mht","file:///E:\My
Documents\Travel\2005\Data\12345.mht")

I'm not sure if it'll work. Let me know.


"Ron" wrote in message
...
In an Excel 2002 worksheet I need to change the destination folder in
a column (750 rows) of hyperlinks.

For example:

file:///C:\Documents and settings\myname\Application
Data\Microsoft\Data\12345.mht

needs to be changed to

file:///E:\My Documents\Travel\2005\Data\12345.mht


file:///C:\Documents and settings\myname\Application
Data\Microsoft\Data\56789.mht

changed to

file:///E:\My Documents\Travel\2005\Data\56789.mht

All the ".mht" files are now in the folder E:\My
Documents\Travel\2005\Data\

TIA