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