You may use it to bring up the Edit Hyperlink Dialog and extract your hyperlinks.
Heres how:
Step 1:Launch Excel on your setup and pop pop the document with hyperlinks.
Step 2:punch theSheettab with the hyperlinks and choose the cell with the hyperlinks.
Step 3:Right-tap the cell with the hyperlink to launch the context menu.
Step 4:SelectEdit Hyperlinkto launch the Edit Hyperlink dialog box.
Step 5:Place your mouse cursor in theAddressfield of the Edit Hyperlink dialog box to highlight the URL.
Step 6:Right-poke the highlighted URL and selectCopy.
Alternatively, you’ve got the option to use the shortcutCtrl+Cto copy the URL.
Step 7:ClickOKto end the Edit Hyperlink dialog box.
Alternatively, you could paste the URL using theCtrl+Vshortcut.
Copy the hyperlinks from your Excel to a Word document, then save the Word document as HTML.
Heres how:
Step 2:punch theSheettab with the hyperlinks and copy all cells with the hyperlinks.
Step 3:Open a new Word document and paste the copied hyperlinks into the document.
Step 4:PressCtrl+Sto launch the Save window in Microsoft Word.
Alternatively, click theFiletab on the Ribbon and selectSave Asto launch the Save As window.
Step 5:Enter a name for your file in theFile namefield.
Step 6:Click theSave astype drop-down andselect .html.
Step 7:ClickSaveto create the .html file.
Step 8:Open your Windows File Library and navigate to the location with your saved .html file.
Step 9:Right-tap on the file, clickOpen with, then selectNotepad.
Step 10:Copy the content of the HTML file and paste it into a Word document.
Step 11:Click theCtrl+Hkeys on your keyboard to launch the Find and Replace dialog box.
Alternatively, click theReplacebutton on theHometab.
Step 12:In theFind whatfield, enter the unwanted code surrounding the hyperlink.
Step 13:In theReplace withfield, leave a blank space and clickReplace All.
This ensures all unwanted code are replaced with a blank space.
Step 14:Repeat steps 12 and 13 to remove all unwanted code until only the hyperlinks are left.
Step 15:Lastly, copy the hyperlinks and transfer them to a blank column in Excel.
This is particularly useful when working with a large data set.
Heres how to do so:
Step 2:Click theAlt+F11keys on your keyboard to initiate the VBA window.
Step 3:On the VBA window, click theInserttab.
Step 4:SelectModulefrom the options to launch the Module window.
Step 5:Copy and paste the following code into the Module window.
Step 6:Click theRuntab and selectRun Sub/UserForm.
Step 7:Lastly, kill the VBA window by clicking theAlt+Qkeys.
Your extracted hyperlinks should show up in a new column.
Was this helpful?
The content remains unbiased and authentic and will never affect our editorial integrity.
