Just tried it in this way. First copy your values then Mark the spot where you want to add them and then Edit > Paste 4th Values option. Another note, also used more often because: hyperlinks from the text go to the other column:
Alt + F11 and Insert> Module and paste code. Alt + Q and save. The feature is found under "Custom" in the dialog box (Shift + F3). GetAddress = (A1) Where cell A1 for example has a hyperlink.
Function GetAddress (hyperlink cell As Range)
GetAddress = Replace _
(HyperlinkCell.Hyperlinks (1) Address, "mailto:". '")