View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default bulk removal of hyperlinks

Hi Tim,

Another way is to copy an empty cell
Select your entire column
Then EditPaste Special,
Check Add and OK out.

Make sure the cell you copy is truly empty

HTH
Martin

"Tim" wrote in message
...
How can I remove any and all hyperlinks in a column of data ? The only
thing I can find is removal one cell at a time ?

Thanks, Tim