Either of these:
(1) Right-click, remove hyperlink in each cell.
(2) Highlight all cells, Copy (ctrl-c); then in another column, Paste
Special, Values (alt-e,s,v)
To prevent emails, URLs and UNC paths from automatically becoming hyperlinks
when entered/edited, change the AutoCorrect options:
Sub removehyperlinks()
Selection.Hyperlinks.Delete
End Sub
or
type 0 in any blank cell
then copy the cell
select the data with hyperlinks
right click ->paste specia -> multiple and click on ok
On Fri, Nov 11, 2011 at 1:01 PM, Anil Saxena wrote:
> Hi All,
> How can we remove the hyperlink