You maybe interested in this utility: Convert Hyperlinks If you have Kutools for Excel, you can use its Remove Hyperlinks Without Losing Formatting utility to convert hyperlinks from a selection, the active sheet, the selected sheets or the whole workbook.Īfter free installing Kutools for Excel, please do as below:Īpply the utility by clicking Kutools > Link > Remove Hyperlinks Without Losing Formatting, then select the option as you need. Note: With this VBA, all the hyperlinks in the current worksheet will be converted to plaint texts. Press F5 key or click Run button to execute this VBA, then all the hyperlink in the whole worksheet have been converted to plain texts. Click Insert > Module to show a new Module widow, and then paste below VBA code to the Module window. Press F11 + Alt keys simultaneously to open Microsoft Visual Basic for Applications window.Ģ. If you like to use VBA code to solve task, you can do as below steps:ġ. For removing multiple hyperlinks, you need to repeat this method for many times. Note: In Excel 2007, you can only remove one hyperlink at a time. Now the selected hyperlinks have been converted to plain texts. Select the hyperlinks you want to convert, and right click to show the context menu, then select Remove Hyperlinks option from it. In Excel, you can use the right click menu to convert clickable hyperlinks to plaint texts. Supposing you have multiple clickable hyperlinks in a worksheet, and now you want to convert these hyperlinks to plain text, do you have any good tricks to solve this job? Now this tutorial introduces some tricks to quickly handle the job in Excel.Ĭonvert hyperlink to plain text with right click menuĬonvert hyperlink to plain text from selection/worksheet/workbook with Kutools for Excel
LINK TO TEXT CONVERTER HOW TO
How to convert hyperlink to plain text in Excel?
0 kommentar(er)
