How to detect characters in cell?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to detect characters with a cell? 12
How to determine char or number? 4
How to retrieve the value within string? 10
How to determine the value within specific cell position? 5
How to sort names in alphabetical ascending order? 7
How to determine the values? 1
How to count the number of occurrence within string? 2
How to match the values within Tables? 1

Top