The MID and MIDB functions in Excel return a specific number of characters from a text string starting at the position you specify.

VBA is a powerful program that enables non-programmers to create and edit macros. Learn how to enable & use VBA in Microsoft Excel.

When a conditional formatting rule is overkill, use these VBA procedures to highlight duplicates and then remove the highlighting in Microsoft Excel.