I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

You may want to keep some of the names that you defined -- or keep the names
that excel uses that you didn't know even existed.

GOH wrote:

I have many names inherited from copying worksheet from external files, the
file now contains hundreds of names that is giving me some problems. Apart
from deleting one at a time using 'Insert'-'Name'-'Define', wonder anybody
know how I can delete all the names completely.

--

Dave Peterson