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

list box item 4
Cell data entering slow! 0
copy cell only with contains 3
@which function to use when 5
Excel does not accept text format! 0
Creating Labels Over 3-Up Image 2
Formula to answer YES or No 4
How do I locate cells that contain a certain text? 2

Top