Same contents but not equaled

[MFS]

Hi all,
The problem is that I have to cells which have the same contents, but Excel
dose not recognize them as equaled cells?
Please check this example and help me.
A1=R123.
B1=R123.
C1=IF(A1=B1;"Yes";"No")
The result is No,, I could not understand this.
Please help me.

 

[Bernard Liengme]

Is this really what you have or are you simplifying it for us?
What is displayed in A1 and B1? Are they numbers?
What is the result of =A1=B1 (should be TRUE)
If you wish, please, send me sample file - email address is on my website
best wishes

 

[MFS]

Hi,
Conceder A1 and B1 are text, which is “R123†for example.
IF(A1=B1;"Yes";"No")
The formula is saying that if A1=B1, if true give me Yes, if false give me No.
But the result is No, how it becomes false?? That is my question

 

[Mike H]

Hi,

Maybe you have spaces, try this

=IF(TRIM(A1)=TRIM(B1),"Yes","No")

Mike

 

[Bernard Liengme]

Tell me what you get from these two formulas
=A1=B1
and
=LEFT(A1,4)=LEFT(B1,4)

best wishes

 

[MFS]

Hi Bernard,
I will give you the sample after I try Mike’s suggestion and yours
To be honest I did not expect that I will need to provide a sample, because
I have the file in another PC

 

[MFS]

Hi,
I tries Mike’s suggestion and yours, both of them helped me.
Thanks a lot.