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.

JE McGimpsey wrote:

See

http://www.mcgimpsey.com/excel/nohyperlinks.html

Thanks. Might try the first macro out of curiosity (and to refresh my
skills in how to install macros anyway <g), but that Paste Special
Values method from i-Zapp looks simpler!

--
Terry, West Sussex, UK