IF CONTAINS
 

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

=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