matching text to text in excel
 

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.

matching text to text in excel
 

=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.

matching text to text in excel
 

Thankyou - went completly blank when doing it.

Am still probably going to need something more as I just found I could have
e.g Flat a, 21 Moore Park, in one colum and the next just "21 Moore Park" I
think I will need a formula that looks for "like" for Like Words in both
colums

But thankyou this did help.

"Stefi" wrote:

=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.

matching text to text in excel
 

=ISNUMBER(SEARCH(B1,A1))

returns true if B1 is contained in A1. Searching with wildcard characters
can also help you, make a search in Help with lokkup words "wildcard
characters"!

Regards,
Stefi

€žIkepri€� ezt Ã*rta:

Thankyou - went completly blank when doing it.

Am still probably going to need something more as I just found I could have
e.g Flat a, 21 Moore Park, in one colum and the next just "21 Moore Park" I
think I will need a formula that looks for "like" for Like Words in both
colums

But thankyou this did help.

"Stefi" wrote:

=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.