=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
|