Hello all,

Thank you for stopping by. I have a spreadsheet with many rows. Each row has an ID made up of numbers and letters. For some reason, when I exported the data from our database some records were duplicated. However, the duplicated records have the letters in the ID lowercase. I need to remove the duplicate rows that have the ID letters lowercase and I need to keep the ID's with uppercase letters.

Is there a formula or VBA that will do this for me?

Example 1:
123RT456 - (keep)
123rt456 - (remove)

Example 2:


9123847JH2351234H - (keep)
9123847jh2351234h - (remove)

I really appreciate your help!

Rey