Remove Hyperlinks in a lot of cells at once

[rbraxton]

How do I change a large range of hyperlinks to just plain text?

_________________
ricochetrobbed!
This message was edited by rbraxton on 2002-11-05 17:01

 

[Ekim]

1. Put the number 1 into a cell
2. Right click - Copy
3. Select the range with the hyperlinks in it (you may have to start one row above or below the range in order to be able to select without activating a link)
4. Right click - Paste Special...
5. Check the "multiply" option in the Operation section
6. Click OK

This "multiples" the values by 1, which converts them back to plain text.

Regards,

Mike

 

[Von Pookie]

Or, just download ASAP Utilities, select what cells you want to change, then go to ASAP Utilities|Web|Remove all hyperlinks in selected cells.

Sounds easier to me, personally, but do what ye will

 

[rbraxton]

Great!
Thank you both :wink:

 

[dtaylor]

or from the vba editor you can use this line

Sub RemoveHyperLinks()
'Keyboard Shortcut: Ctrl+Shift+Q
ActiveSheet.Hyperlinks.Delete
End Sub

this will delete all hyperlinks in the activesheet.

i placed this in my Personl.xls file - a file that i have in the Xlstart folder and contains many functions and routines i use on a daily basis.

regards

dan

 

[Juan Pablo González]

Another option, in the VBE Inmediate Window (Ctrl G) type

ActiveSheet.Hyperlinks.Delete