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. Tried a macro to no avail. Thanks
View best response
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.
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.
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 hyEnd Sub
Thank you! You are my hero!