I apologize in advance if this is already posted somewhere - I searched the forum for about 30 minutes and wasn't able to find the answer.

I'm trying to find a formula that will ignore text when searching for duplicates contained within the same column. For example, the column contains the following:

WS-X4606-X2-E
WS-X4606-X2-E=
WS-X4606-X2-E=
WS-C4960=
WS-C4960

The = should be ignored and these should all be highlighted as duplicates.

Any help would be greatly appreciated!