Hey everyone,

I have an excel file and it's full of record IDs such as 001E000000BX6Lk. The problem is, the system it comes from is case sensitive, so I also have records like 001E000000BX6LK. Exactly the same but the K is capital in one and small in the other.

I'm trying to split the file in two, so that some are on one file and some on the other. If I say highlight duplicates though, it highlights them all since they're all technically duplicates. Is there a way to highlight it in the way that I want? So for example if I had these 4 records:

001E000000BX6Lk
001E000000BX6LK
001E000000Bd9eu
001E000000Bd9Eu

It would highlight like:

001E000000BX6Lk*highlight
001E000000BX6LK
001E000000Bd9eu*highlight
001E000000Bd9Eu

Is there any way to highlight that way? I need to run these through a service checking tool, and when it exports from that tool it puts everything in capitals. So when I go to re-import this excel file into Salesforce it doesn't know what record belongs to what account since it's changed them all. Thanks!