Removing hyperlinks from a whole column

Giganews Newsgroups
Subject: Removing hyperlinks from a whole column
Posted by:  Craig Thomson (
Date: Tue, 28 Oct 2003

I have recently cut and paste a table from a web page into a
spreadsheet. Unfortunately it has also copied in the link information
as well. This drives me nuts, as whenever I click on the cell my
browser opens. I have no need for the link so want to get rid of it.

I can remove the link on an individual cell by right-clicking and
selecting Hyperlink->Remove Hyperlink. However I cannot find a way to
do this for the entire column at once.

Thanks for any suggestions.