Removing Hyperlinks

[Sloth]

I cut and pasted some information off of the internet onto a spreadsheet.
How can I remove all of the hyperlinks contained in the spreadsheet quickly?
I know how to do it individually, but there has to be a way to speed it up.

 

[bj]

I use the macro found in
http://sniptools.com/tipstricks/deleting-all-hyperlinks-from-a-microsoft-office-document

 

[Shatin]

Simplest way is to run this macro:

Sub removeHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub

If you prefer a non-macro method, try this:

http://exceltips.vitalnews.com/Pages/T1009_Removing_Hyperlinks_without_a_Macro.html

I cut and pasted some information off of the internet onto a spreadsheet.
How can I remove all of the hyperlinks contained in the spreadsheet quickly?
I know how to do it individually, but there has to be a way to speed it

up.