SOLVED

# why is Excel returning False

Brass Contributor

# 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

5 Replies
best response confirmed by wanalearn (Brass Contributor)
Solution

# Re: why is Excel returning False

A1 contains "Abdullah, Hala", but C1 contains "Abdullah, Hala " with a space after the name.

# Re: why is Excel returning False

@HansVogelaar WOW how did you figure this out?

is there a formula or function to highlight the differences from one cell to another?

# Re: why is Excel returning False

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:

# Re: why is Excel returning False

Think's, i am asking if it can highlight the difference in the cell itself like the which part of the text is different

# Re: why is Excel returning False

That would be difficult.

1 best response

Accepted Solutions
best response confirmed by wanalearn (Brass Contributor)
Solution

# Re: why is Excel returning False

A1 contains "Abdullah, Hala", but C1 contains "Abdullah, Hala " with a space after the name.