How to keep hyphen in a string and remove all specific characters

Hi All,

I have a column with so many names and want to remove all specific characters from each name/cell.

I tried with below codes, which are available at below link, but this trick also removes hyphen sign from the names:
http://www.ozgrid.com/forum/showthread.php?t=55082

Please Login or Register  to view this content.

I don't know if my logic is the same as yours, that is, if we find "-" (hyphen) sign in a string, and that sign has any alphabet character before and after, so it can be good to go.
I am looking for your help.

Examples:
"Amparo Dablo-Victoria121" should be as "Amparo Dablo-Victoria" name.
"Robert Kearney (07-15-1986)" should be as "Robert Kearney"
"James *Bond III" should be as "James Bond III"


Thanks in Advance!

Thank you so much Ed_Collins!!
It's very good!