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

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.

Tim wrote:

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

--

Dave Peterson

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