Dear Dave,

I can't follow your instruction starting from "ctrl-g (to see the immediate
window)"
and where should I type "selection.hyperlinks.delete"?



"Dave Peterson"
...
select your range to clean
alt-f11 (to see the VBE)
ctrl-g (to see the immediate window)

type this and hit enter
selection.hyperlinks.delete

And then close this window and go back to excel.

Kent wrote:

Dear all,

I have got some hyperlinks in my excel worksheet which may be removed and
replaced by characters one by one. HOw can these hyperlinks be removed
all
in the same time?

Thanks you

--

Dave Peterson