hi all,

i hope you can provide me a vba for deleting duplicate text, actually not exactly duplicate. i.e
in column D i have:
Mekarjaya
Mekarjaya (2)
Mekarjaya (UKM)

for example in above, i want to delete row for Mekarjaya (2) and Mekarjaya (UKM) and leave Mekarjaya only.

i have you can help me.

many thanks

reza