How to detect characters in cell?

E

Eric

Does anyone have any suggestions on how to detect whether the cell contains
the character "ND" within string or not? If the cell under B column contains
any character "ND" within string, then return "" in C column.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
D

Dave Peterson

=if(countif(b1,"*ND*")=0,"not there","")
or
=if(isnumber(search("nd",b1)),"","not there")
or
=if(isnumber(Find("ND",b1)),"","not there")

=find() is case sensitive.
=search() is not case sensitive.
The =countif() is not case sensitive, too.
 
Top