matching text to text in excel

I

Ikepri

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

Stefi

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

Regards,
Stefi

„Ikepri†ezt írta:
 
I

Ikepri

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

Stefi

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
Macro to Select text from a point given to a specific word 2
I'm John, My first post. 0
How to modify and updte specific styles for specific paragraphs across the document 0
first ten and last ten averages 2
Address Format changed after Migration 0
Select minimum with duplicate values to return column headings 3
Finding the right style field in VBA 0

Top