=LEFT(A1,10)=LEFT(B1,10)
returns TRUE if the first 10 characters are the same.

Regards,
Stefi

€žIkepri€� ezt Ã*rta:

I have two sets of address in two colums, I want to only look at those that
are different. First problem is some are the same but not entered exactly the
same.

If there is a was of counting the first say ten characters of colum a and
first ten of colum b and check if similar this would help.