if statement - comparing two text strings in excel to find if they match -

i have derived file using 2 different methods; foxpro , sql. because familiar it, decided compare 2 end results in excel see if identical. 79,954 rows needless say, not going line line. first, want see if company names same. create new tab , put company name columns each next each other. there, first method used

 =exact (b2,c2) 

it returns false value when can see eyes not true. next use simple if statement,

 =if(b2=c2,0,1) 

it returns value of 1.

is there better method of doing this?

exact case sensitive need sure don't have up/low letter mismatch.

you can use equal not case sensitive:

=b2=c2 

this formula return true or false.

if it's still not working perhaps have spaces or other hidden characters. solution check if b2 includes c2 , opposite.