Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare part of text cell to another
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare part of text cell to another
Hi Nev
You may be able to use the search function. =SEARCH(A2,B2) Dan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare part of text cell to another
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare part of text cell to another
Dan
That's great. How do I stop #value! if the result is false. I want to leave the cell blank or say no/false Thanks Nev "dan dungan" wrote: Hi Nev You may be able to use the search function. =SEARCH(A2,B2) Dan |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare part of text cell to another
Hi Jacob
Thanks but perhaps you need a bit more information Cell 1 address is formatted using Alt Enter ie Union Buildings Union Square Bradford Cell 2 25 Union Buildings Union Square Bradford Yorks BD5 8NN I would like to be able to compare the 2 and that cell 1 is contained within cell 2 so answer is "y" or "n" Can you help? thanks Nev "Jacob Skaria" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF cell contains part of text | Excel Worksheet Functions | |||
Finding text or part of a text inside the value cell | Excel Programming | |||
find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
USE PART OF TEXT FROM ONE CELL IN ANOTHER | Excel Discussion (Misc queries) | |||
Compare part of a cell to a column | Excel Discussion (Misc queries) |