Forum Discussion

Copper Contributor

Jun 19, 2018

Solved

Editing hyperlinks in bulk

I have a speadsheet that has the emails but only as hyperlinks. I just want to make this a plain text doc with the email addresses and don't want to have to click and edit each record individually. T...

excel

Formulas and Functions

Macros and VBA

Haytham Amairah

Jun 21, 2018

Hi Kim,

Please try this code.

Sub GetHyperlinksAddresses()

'Written By Haytham Amairah

    Dim hy As Hyperlink
    
    For Each hy In ActiveSheet.Hyperlinks
        hy.Range.Value = hy.Address
        hy.Delete
    Next hy

End Sub

Regards

Damien_Rosario

Silver Contributor

Jun 19, 2018

Hi Kim

Have you tried saving the Excel doc as a CSV or txt file (File > Save As)?

In either option, it will give you the addresses as plain text without the hyperlinks.

Cheers

Damien