Wildcards in IF statements

C

Calvin

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

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
 

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

Repeated phrases wildcard? 1
How to count the numbers in a Word document? 0
Removing a repeated words 0
Page numbering with Merged Document and IF statements 1
Deleting all but one occurrence of text from a selection 0
Incone & Expenses Statement 0
Macro for intelligent wildcard pattern modification 3
Coding wildcards in search criteia 2

Top