Thread: IF cell contains part of text
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default IF cell contains part of text
=IF(COUNTIF(A1,"*16z*"),"yes","no")


"Supe" wrote:

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