Could additional spaces be a problem?

Try this

=(TRIM(G5)=TRIM(O5))*1

Mike

"scubadiver" wrote:


The two columns I am comparing are text. In another column I have this:

=IF(G5=O5,1,0)

As an example, I have "237A98" in the same row in G5 and O5 but when I
evaluate this function it brings back '0', not '1'.

Anyone know why?