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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks