ActiveSheet.Hyperlinks.Delete
End Sub
Also at that interface, click the Run Sub / User Form or F5 key to get the program to delete the link in the article.
Appears the Macros window interface. Select Run to proceed to delete Hyperlink.
Finally turn off Visual Basic. The result returned is the Excel data table that has been deleted.
Above, we showed you how to delete link links on Excel using Visual Basic statements. Now, you can copy all the text after removing Hyperlink following the above tutorial.
I wish you all success!