| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count if matching text | Excel Worksheet Functions | |||
| Matching 2 Text fields | Excel Worksheet Functions | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| Matching Two Text Strings to see if Like | Excel Worksheet Functions | |||
| Matching Text | Excel Worksheet Functions | |||
Linear Mode
