IF cell contains part of text

[Supe]

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

 

[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

 

[Per Jessen]

Look at this:

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

Regards,
Per

 

[Teethless mama]

=IF(COUNTIF(A1,"*16z*"),"yes","no")