Finding Duplicate strings of text/numbers

Hello,

First of all, thanks in advance for any help provided.

Here is the issue, I'm trying to find a way to find duplicate string of values in a sheet
Example:

1- ZZZ-ABCD-12345A
2- ZZZ-ABCD-12345B
3- ZZZ-QWE-1346A
4- ZZZ-QWE-1346B
5- ZAA-POU-9876B
6- ZAA-POU-9876A
7- ...
8- ... etc

I need to either highlight the common values or assign another column so its easier to sort them out, Thanks again for any assistance again.

Hi Lamm3rrr and welcome to the forum,

I'd create a Helper Column and use the Mid() function to extract the strings. Then test the Helper for duplicates.

If your strings are in Column A starting in A1 then this would be my function:

=Mid(A1,5,9)

See if that works for you. Using your example above that will work. If you have more involved data it may not work.