By default, it will actually apply a lot more formatting than just convert your URLs. Once you have the tool setup, just click it and follow the prompts.
You’ll find good instructions on how to do that on the AddinTools website. You can add this accessible by adding it to your Quick Access Toolbar. Although you won’t find it in any menus, the functionality still exists in current versions of Word. You can find a good description of how to do this as well as an example of how to use it by visiting:Ī much simpler approach would be to use an old feature of Word called “AutoFormat”. It will also be available through the Object Browser (F2). To enable this, you will need to:ġ) Start the Visual Basic Editor in Word.ģ) Check the box next to the “Microsoft VBScript Regular Expressions 5.5” option.įrom this point on, you will be able to create a RegExp object in your VBA script. By the way, regular expressions are not enabled by default so you will need to enable it. If you really wanted to pursue this approach, I would recommend you look into using regular expressions to search through the contents of the document for patterns which match URLs.
Unfortunately it would be somewhat more complicated to achieve the same results in Word because it just contains free form text. In Excel, the script makes an assumption that each cell contains a URL. Intersect(Selection, ActiveSheet.UsedRange).Hyperlinks.Delete ' Purpose: Removes the hyperlinks from the selected range leaving the text. ' Copyright 2011-2012 TNG Consulting Inc. Press ALT+F8 to open the Macro selector window and click on the macro you just created.Īnother macro you might find useful helps you remove the selected hyperlinks, leaving just the text: ' Written by: Michael Milette.To execute the macro, select the text links you want to convert to clickable hyperlinks.
The first parameter is the cell address that contains the URL and the second refers to the text you want to have appear in the cell. This first method uses a formula to create a hyperlink enable version of the cell in an adjacent cell: Method #1: Use an Excel formula to create hyperlinks Note that neither of these two methods do any validating to ensure the result is actually a valid hyperlink.
Have you ever had an Excel spreadsheet full of web addresses that were not clickable? Pressing F2 and ENTER is good enough when you only have a few, but when you have dozens, hundreds or even thousands, this can become a very time consuming task.įortunately there are a couple of approaches which will save you tons of time.