I have an excel 2007 worksheet that has thousands of lines. All of them include at least one link to an email (email). I need to remove the hyperlink and show the actual emails for sorting purposes. I can do it manually but it will take hours. Can anyone help with a macro or VBA formula?
Bookmarks