How do a search for a text string using a formula

B

BobbyG

Is it possible to use a =IF(A1=%TEXT%,"A","B") or
=IF(CONTAINS(A1,TEXT)=TRUE,"A","B") type formula? Like you can do using
autofilter but in a formula?
 
D

Dave Peterson

=if(countif(a1,"*text*)>0,"a","b")

is one way.


Is it possible to use a =IF(A1=%TEXT%,"A","B") or
=IF(CONTAINS(A1,TEXT)=TRUE,"A","B") type formula? Like you can do using
autofilter but in a formula?
Click to expand...
 
Top