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

[keshavtale]

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

[JohnTopley]

Please Login or Register  to view this content.

[windknife]

One guess,

Please Login or Register  to view this content.

[keshavtale]

VBA code provided by you it should also remove bracket and it's text and remove hyphen
for example if in A column there is name santa (hyd) - 250 then result should be santa

[Sintek]

Please Login or Register  to view this content.

[JohnTopley]

See post 3: in future, give examples which reflect all needs.

[keshavtale]

Thanks now my problem solved