How to remove multiple hyperlinks in Excel?
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The change in autocorrect options didn't solve the problem. If I paste from a site, links are still hyperlinks in the worksheet.
Clear all formats removes all formatting. I wanted to save the text & color formatting. But it apparently is the best solution. Thanks.
Clear all formats removes all formatting. I wanted to save the text & color formatting. But it apparently is the best solution. Thanks.
Wow, clear all formats isn't working now. It removed the color & font formatting, but left the hyperlinks.
2.jpg