Forum Discussion
Solved
why is Excel returning False
see attached i don't see a reason why excel returned false when i did on cell d1 =a1=c1
A1 contains "Abdullah, Hala", but C1 contains "Abdullah, Hala " with a space after the name.
5 Replies
A1 contains "Abdullah, Hala", but C1 contains "Abdullah, Hala " with a space after the name.
HansVogelaar WOW how did you figure this out?
is there a formula or function to highlight the differences from one cell to another?
If you click at the end of the cell contents of C1, you'll see the space:
You can also use the formulas =LEN(A1) and =LEN(C1). You'll notice that the second one returns a larger number.
And you can use conditional formatting to highlight a cell if it is not equal to another cell:
Result:
