Removing hyperlinks in bulk
 

copy the range you just pasted, and paste it again to another location
(like another sheet) using "paste special, values".


--
i-Zapp
------------------------------------------------------------------------
i-Zapp's Profile: http://www.excelforum.com/member.php...fo&userid=5768
View this thread: http://www.excelforum.com/showthread...hreadid=479222

Removing hyperlinks in bulk
 

i-Zapp wrote:


copy the range you just pasted, and paste it again to another location
(like another sheet) using "paste special, values".

Excellent, thanks. Seems to work a treat.

--
Terry, West Sussex, UK