bulk removal of hyperlinks

T

Tim

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
 
D

Dave Peterson

Select the range that should have the hyperlinks removed
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Then back to excel to check.
 
M

MartinW

Hi Tim,

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

Make sure the cell you copy is truly empty

HTH
Martin
 
Top