Removing Hyperlinks

[ezeetyger]

I have created a list of comapnies, but unfortunately they are all
hyperlinks, about 3,000 in all. How can I remove the hyperlinks in
one go as opposed to individually?

 

[Kevin Stecyk]

Hi,

See John Walkenbach's site at

http://j-walk.com/ss/excel/usertips/tip031.htm

You can delete all hyperlinks quickly and easily using a very short macro.

Regards,
Kevin