Find/Replace within links in cells

S

Sean Carter

Hi,

I've got a couple hundred links to folders in an excel spreadsheet. The
folders are all moving to another drive. Is there a way I can do a
Find&Replace but within the hyperlinks?

For example, on every link I would want to change
"\\fs_users\Everyone\USER\Paper Archive\" to "C:\Documents and
Settings\USER\Desktop\Paper Archive\"

Is this possible in Excel 2000? If not, maybe in a newer version?

Thanks,
Sean
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting URLs in comments to Markdown-formatted links 2
Word macro that can call cells out of Excel for a find and replace 0
Shortcuts in OneDrive 0
Need Help with Macro Security 1
Active Content in this file is blocked issue 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
how can i change a sequence of numbers using find replace 2
Confusion over where user templates are stored in Word 1

Top