How would I change all hyperlinks at once?



I have a large spreadsheet that incorporates hundreds of hyperlinks to
documents that are all housed within the same folder. For security, I want
to convert all of the documents to .pdf format then change all of the
hyperlinks so that they no longer reference the .doc files and instead
reference the .pdf files of the same name.

If it were within the main portion of the spreadsheet, I would basically be
doing a "Find and Replace" and with ".doc" and ".pdf"; however, I know of no
such option with regards to hyperlinks (though, naturally, I didn't realize
this until after I linked all of the doc files).



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