IF CONTAINS

[Bill Ridgeway]

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

 

[Bob Phillips]

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

if case sensitive

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

if not