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 |
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) |