|
|
|
|
Removing hyperlinks in bulk
See
http://www.mcgimpsey.com/excel/nohyperlinks.html
In article ,
Terry Pinnell wrote:
A worksheet I prepared contains a lot of hyperlinks. (I pasted some
cells in from a web site.) I can see how to remove each one
individually with R-click Hyperlink Remove Hyperlink. But so far
haven't found a way to do it for an entire column, or the whole sheet.
Working with the sheet is awkward, as I often inadvertently open a
link in my browser when all I want to do is copy the text in that
cell.
|