Somthing like this...If matching will return true; if not blank..

HIGH STREET, HIGH STREET 120 will return true
HIGH STREET 120, HIGH STREET will return true
HIGH STREET 120 , HIGH STEET 150 will return blank

A1 = Address1
B1 = Address2
C1 = IF(ISERROR(FIND(B17,C17))+ISERROR(FIND(C17,B17))<2 ,TRUE,"")



If this post helps click Yes
---------------
Jacob Skaria


"Nev" wrote:

Hi there

I want to compare cell 1 with cell 2.

Cell 1 contains an address without the house number.

Cell 2 has the same address with the house number.

I want to be able to compare the 2 cells and if they are the same (excluding
the number) the answer is TRUE

Can this be done?

thanks

Nev