1. Select the range of url text that you want to convert to clickable hyperlinks.
2. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
3. Click Insert > Module, and paste the following code in the Module Window.
4. Then press F5 key to run the code, a pop up dialog for you to select a range, then click OK, and the selected unlinked urls have been converted to the clickable hyperlinks.