Online chat 24/7

01.06.2022
21711

How To Convert A Hyperlink To Plain Text In Excel


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.

2
3
4
5
6
Sub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End Sub

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.

Write a review
Note: HTML is not translated!