reza_doang
07-16-2010, 04:56 AM
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
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