Converting A Hyperlink To Plain Text Using VBA
If you want to use VBA code to solve a problem, you can do the following steps:
1. Press F11+Alt keys simultaneously to open the Microsoft Visual Basic for Applications window.
2. Click Insert > The module show the new widow Module, and then paste the VBA code below into the Module window.
VBA: Converting hyperlinks to plain text.
3. Press the F5 key or click the Run button to execute this VBA, then all hyperlinks on the entire sheet have been converted to plain text.
Note: With this VBA, all hyperlinks on the current sheet will be converted to plain text.