Home |
Search |
Today's Posts |
#1
|
|||
|
|||
what function can i use to tell me if 2 text cells are the same?
I am trying find a way of Excel telling me if 2 cells are the same (usually
Text) ie cell a1 = rabbit and cell b1 = rabbit the function would give me TRUE, and cell a1 = rabbit and cell b1 = dog the function would give me FALSE... Help please |
#2
|
|||
|
|||
=A1=B1
HTH Jason Atlanta, GA "lonejedi" wrote: I am trying find a way of Excel telling me if 2 cells are the same (usually Text) ie cell a1 = rabbit and cell b1 = rabbit the function would give me TRUE, and cell a1 = rabbit and cell b1 = dog the function would give me FALSE... Help please |
#3
|
|||
|
|||
=a1=b1
This gives a false of there are leading or trailing spaces in one cell that don't appear in the other, even though the other characters appear to be the same, so an alternative is =trim(a1) = trim(b1) Neither of these are case sensitive. If you need to check for case, too, use =exact(a1,b1) "lonejedi" wrote: I am trying find a way of Excel telling me if 2 cells are the same (usually Text) ie cell a1 = rabbit and cell b1 = rabbit the function would give me TRUE, and cell a1 = rabbit and cell b1 = dog the function would give me FALSE... Help please |
#4
|
|||
|
|||
=A1=B1
-- HTH Bob Phillips "lonejedi" wrote in message ... I am trying find a way of Excel telling me if 2 cells are the same (usually Text) ie cell a1 = rabbit and cell b1 = rabbit the function would give me TRUE, and cell a1 = rabbit and cell b1 = dog the function would give me FALSE... Help please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UPPER text function | Excel Discussion (Misc queries) | |||
Referencing cells text output if it meets specific conditions | Excel Worksheet Functions | |||
Combining & formatting cells with text - Excel 2002 | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) |