How To: Remove all hyperlinks on a sheet in Excel 97/2000/2003/XP
When you copy and paste website content from browser to Microsoft excel, the formatting of the text is retained to the extent that the unerlying hyperlinks also get pasted. If you have pasted a large portion of text, then it is a time consuming task to remove those hyperlinks from all the cells. Here is a short tutorial on creating a macro in excel to help you remove all the hyperlinks quickly. It’s very easy, just copy and paste few
Continue Reading




