Macro to convert hyperlinks to text
 

I have lots of hyperlinks in a worksheet, want to convert them all into plain
text. I couldn´t find an automatic way to do this other than with macros,
does someone have a macro that do this?

Thanks in advance

Regards
Emece.

Macro to convert hyperlinks to text
 

Sub RemoveHyperlinks()
Selection.Hyperlinks.Delete
End Sub

Select the range that has the links (could be the entire sheet), Press
Alt-F8 the run the macro.

- John