C Calvin Feb 8, 2004 #1 OK I have tried to do this on my on but..... ok Wildcards in I statements, can and how is this done
P Peo Sjoblom Feb 8, 2004 #2 There are some ways to do this =IF(COUNTIF(A2:A2,"?abc"),"yes","no") =IF(COUNTIF(A2:A2,"*abc"),"yes","no") =IF(COUNTIF(A2:A2,"*abc*"),"yes","no") =IF(ISNUMBER(FIND("abc",A2)),"yes","no") =IF(ISNUMBER(FIND("abc",A2)),"yes","no") and so on
There are some ways to do this =IF(COUNTIF(A2:A2,"?abc"),"yes","no") =IF(COUNTIF(A2:A2,"*abc"),"yes","no") =IF(COUNTIF(A2:A2,"*abc*"),"yes","no") =IF(ISNUMBER(FIND("abc",A2)),"yes","no") =IF(ISNUMBER(FIND("abc",A2)),"yes","no") and so on
