IF cell contains part of text

S

Supe

Want to create an if fuction that will give a result of "Yes" if any part of
the cell cotains 16Z.
 
M

Mike H

Try

=IF(ISERROR(SEARCH("16Z",A1)),"","Yes")

If you want (for example) to say No if it isn't there try

=IF(ISERROR(SEARCH("16Z",A1)),"No","Yes")

If you want it to be case sensitive change SEARCH to FIND


Mike
 

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

copy cell only with contains 3
Monthly Inspection Database 0
Formula to answer YES or No 4
Find certain text in a cell 3
Excel Linking Multiple cells to One cell for Results 0
Can I request user in input variable value within formula? 11
Excel If a Cell Contains a Certain Text (From Another Table) 0
Creating macro 9

Top