Wildcards

[DaveB]

If I am using the code below for column A...meaning I want
to find any words or letters with "CT" in them, what is my
wildcard or code to put in front and in back of "CT" to
have "CORP" OR "NULL" appear in column B.

Thanks.

DaveB

=IF(A21="CT","CORP","NULL")

 

[Max]

Try: =IF(ISERROR(SEARCH("CT",A21)),"NULL","CORP")

 

[Don Guillett]

=IF(A21="CT","CORP","NULL")
try
=if(countif("*ct*",a21)>0,1,2)

 

[Don Guillett]

Of course, I meant
=COUNTIF(a21,"*cd*")

 

[Max]

Of course, I meant
=COUNTIF(a21,"*cd*")

No .. <g>

Think you meant

COUNTIF(a21,"*ct*")

as in
: =IF(COUNTIF(A21,"*ct*")>0,"CORP","NULL")

 

[Don Guillett]

picky<G>