You can do this with a macro:
Sub RemoveHLinks()
Selection.Hyperlinks.Delete
End Sub
Just select the column first. If you aren't familiar with macros, look here
for some intro material:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
tj
"Rasoul Khoshravan Azar" wrote:
I know how to remove a link from a single cell. Right click, hyperlink,
remove hyperlink.
I have a column of cells and it is very cumbersome to remove cell by cell.
Is there any way to remove all cells in one action.?
TIA, Rasoul Khoshravan