* Determine Capitalization
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
|