Thread: COMPARE TEXT
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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"