If 2 cells contain the same string

[fuston05]

trying to see if 2 cells (both containing strings) contain the same string or not, keeps returning false;

Please Login or Register  to view this content.

A8 contains the name Renninger
E8 may or may not contain the name Renninger, or another name need to see if they contain the same name or not.
I think my "=" operator is the issue here..not sure though.
any ideas??

[NBVC]

Perhaps you have some extra spaces in one of the cells?

try:

=IF(TRIM(A8)=TRIM(E8), TRIM(E8), "")

[fuston05]

yea, that worked perfectly..thank you so much.