Hyperlink modifying

D

dwayne

I have an excel worksheet that includes hundreds of
hyperlinks to photographs. I am trying to burn them to CD,
but need to change the current D:\asdf\asdf\asdf
to :\asdf\asdf\asdf so the links still work when burnt to
disk. Is there an automatic way of deleting every D for "D
drive" from the start of every hyperlink or do I need to
change them all manually?
 

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

Top