Consulting

Results 1 to 2 of 2

Thread: delete duplicate text

  1. #1

    delete duplicate text

    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

  2. #2
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •