Select the column.
Alt-F11 (to get to the VBE)
hit ctrl-g (to see the immediate window)
type this and hit enter:
selection.hyperlinks.delete



coastal wrote:

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

--

Dave Peterson