Receiving a false false result on True/False statement

[asb]

Hi,

when comparing 2 identical sets of data in column A and B using True/False statement, it is returning False, instead of True. When I copy the same data from A into B, and run it again, it returns a True. Is there a hidden formatting issue? I have tried everything I can think of to fix it but nothing has worked yet. Any help would be greatly appreciated.

Thanks in advance!

I am using Excel 2007/Microsoft windows XP version 2002

Original attempt:
=IF(A1107=B1107,"true","false")

<TABLE style="WIDTH: 159pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=212><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl459 height=20 width=64>USD</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl461 width=64>USD </TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl460 width=84>false</TD></TR></TBODY></TABLE>


When I copy value from A into B
=IF(A1107=B1107,"true","false")
<TABLE style="WIDTH: 159pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=212><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl461 height=20 width=64>USD</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl461 width=64>USD</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl462 width=84>true</TD></TR></TBODY></TABLE>

 

[VoG]

Maybe one contains trailing spaces.

Try

=IF(TRIM(A1107)=TRIM(B1107),"true","false")