VBA not removing content infront of - (hyphen) and also remove -

please check attached file in that file there is VBA code i use this code to remove () bracket and content between that bracket
from name in A column
in that bracket VBA code remove that content of bracket and also remove bracket and also remove hyphen like this - and
content infront of hyphen but if only
hyphen - VBA not remove you can see in cell A33 - 250 VBA code should remove that - 250 you can see before after sheet so you
can easily under stand