Thread: Removing hyperlinks for all text in a colum shortkey
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Removing hyperlinks for all text in a colum shortkey
Copy an empty cell.

Select the column of hyperlink cells and Paste SpecialAddOKEsc

David McRitchie has code and more suggestion for dealing with hyperlinks.

http://www.mvps.org/dmcritchie/excel...#DelHyperlinks



Gord Dibben MS Excel MVP

On Mon, 25 Jun 2007 13:27:00 -0700, coastal
wrote:

Is there a shortcut to removing the hyperlinks in a column so that there is
only text?

Reply With QuoteReply With Quote