COMPARE TEXT

[Guest]

I need find a way to compare two cells this way
example
Cell A3 Content = UV2345ZC
Cell B3 Content = System closed
The result in Cell C3 should be True if Cell A3 contain "ZC" and Cell
B3 contain "Closed"

 

[Guest]

=AND(RIGHT(A3,2)="ZC",RIGHT(B3,6)="Closed")

 

[PCLIVE]

One way:

=AND(ISNUMBER(SEARCH("ZC",A3)),ISNUMBER(SEARCH("Closed",B3)))

HTH,
Paul

 

[Guest]

=IF(AND(ISNUMBER(SEARCH("ZC",A3)),ISNUMBER(SEARCH("Closed",B3))),"True","False")

 

[David Biddulph]

=AND(ISNUMBER(SEARCH("ZC",A3)),ISNUMBER(SEARCH("Closed",B3)))

If you want the searches to be case-sensitive, then replace SEARCH() by
FIND().