How to detect characters in cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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.
 
Back
Top