PDA

View Full Version : delete duplicate text



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

GTO
07-16-2010, 05:02 AM
I would suggest more sample data and any rules we can count on, such as: will there be a space, will there always be an opening paranthesis, etc.