View Single Post
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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