ayi Use the built in exact() function which is exact-ly for this purpose: =exact(A1, B1) It will return true if the strings are identical.