robertc + microsoftexcel   1

MS Excel: Delete all hyperlinks on a sheet in Excel 2003/XP/2000/97
At work I sometimes use Excel as a sort of hand driven screen scraper to get tables of data off a web page and into a useful format, one issue with this is that the resulting data is littered with hyperlinks which are a pain to remove manually. This is the most straightforward way I found to get rid of them all, works in Excel 2007 too.
MicrosoftExcel  Tips 
december 2010 by robertc

Copy this bookmark: