I have a spreadsheet in Excel 2003 that I created by pasting from a web site. There's a column of hyperlinks. I want to remove all the hyperlinks but want the text to remain. I can do this one cell at a time by right-clicking on a cell and selecting 'Remove Hyperlink'. But if I select more than one cell at a time, I don't have the 'Remove Hyperlink' option. Is there any easier way to replace all of these hyperlinks with text only?
Please note: I have already solved this myself by copying the column into notepad and then pasting it back into Excel. But this eliminates all other formatting. Is there a non-macro way to do this using only Excel so that I can save the formatting?