TRIM alone may not be enough
You never know what you might get when you download data from external sources. TRIM removes unnecessary spaces, but not non-printing characters. I'd take the extra step to say = EXACT(TRIM(CLEAN(A4)),TRIM(CLEAN(B4))) to be sure to remove any other hidden characters.
Keep Up with TechRepublic