I have a large number of different hyperlinks to various different websites in different cells in Excel (2003) and I am trying to change the viewable text in ALL these cells to a simple word link "weblink" rather than see all the hyperlink address.
I know it can be done manually by right-clicking the cell and "Edit Hyperlink" but I would like to do this globally everywhere I have a hyperlink so it doesn't take my all of my natural life to complete the task. Can anyone provide direction?
Thank you.
Bookmarks