Forum Discussion
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...
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 SubRegards
Yes - that just returns the "text to display" which is "Email Me" and not the address. Thanks tho.
Hi Kim,
That's only with VBA (or third-party tools) to extract the address, not display text. Example is here https://superuser.com/questions/691116/extract-url-from-anchor-text-in-excel and you may google for more similar ones.