Hi. I have an bit of an issue. I have an incredibly long spreadsheet, where column C is a list of extremely long hyperlinks. I now need to turn the sheet into a pdf, for printing as well as onscreen use
and want to change the text of column C to "Data Sheet Reference" without losing the hyperlink function. Doing this manually would take weeks if not months. Is there a simple macro or vba script
that can help me wrap this up more quickly?
Any help is much appreciated.
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Probably Simple..." was not a good title. I have updated it for you this time because you are a new member. --6StringJazzer
Bookmarks