MS Office

Now use the =GETURL(cell) to get the URL Example: =GETURL(A1) will return the URL for the Hyperlink displayed in cell A1 Function GETURL(HyperlinkCell As Range) GETURL = HyperlinkCell.Hyperlinks(1).Address End Function

In a Word Document when we paste some data from some source (e.g. Websites). We find that there are some hyperlinks copied into it. Sometimes we want to change the text of all these hyperlinks to a particular word. When it is needed? It is useful where we actually want to remove all these hyperlinks … Read more

To install this all you need to do is: 1. Hit ALT + F11 (Opens Visual Basic Editor) 2. Click on Insert -> Module (adds a module to your excel file) 3. Paste the code 4. Hit ALT + Q (Closes the Visual Basic Editor)