How to remove hyperlink in excel in one shot?

If we have Hyperlink in single cell, we can do right click on cell and click “Remove Hyperlink” to remove

How can we handle, if we have Hyperlink in sheet more than 1000 records ?

Do following steps to remove hyperlink in one shot.

Option A

Select the Hyper-linked cells before you run following macro
Sub Macro()
Selection.Hyperlinks.Delete
End Sub

If you don’t know where to paste above macro.

a)Press Alt+F11 to open VB editor
b)Press Alt+I+M to open Madule
Then paste and press F5 to Run.
Option B
Select the Hyper-linked cells and copy. Paste special and value.

Hope you like this post