There is a built in function in EXCEL to remove the hyperlinks: Select the designated area and go to "Home" ribbon > "Clear" dropdown menu > and press "Clear Hyperlinks" :
Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD
