COMPARE TEXT
 

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"

COMPARE TEXT
 

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


"CC" wrote:

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"

COMPARE TEXT
 

One way:

=AND(ISNUMBER(SEARCH("ZC",A3)),ISNUMBER(SEARCH("Cl osed",B3)))

HTH,
Paul

"CC" wrote in message
...
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"

COMPARE TEXT
 

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

"CC" wrote:

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"

COMPARE TEXT
 

=AND(ISNUMBER(SEARCH("ZC",A3)),ISNUMBER(SEARCH("Cl osed",B3)))

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

"CC" wrote in message
...
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"