Thread: IF CONTAINS
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=ISNUMBER(FIND("text",A1))

if case sensitive

=ISNUMBER(SEARCH("text",A1))

if not

--
HTH

Bob Phillips

"Bill Ridgeway" wrote in message
...
Could someone help please?

I am looking for the Excel formula equivalent of the ?SQL command that

will
return true or false dependent on a text string being found in a

particular
cell.

Thanks.

Bill Ridgeway
Computer Solutions