Thread: "CONTAINS" operator?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default "CONTAINS" operator?
Harlan Grove wrote...
....
=IF(SUBSTITUTE(A1,"ORDER","")=A1,...

Ignore this one. the = comparison was an error.

Reply With QuoteReply With Quote