Wild card question
Posted by Andonny on February 15, 2001 3:41 PM
Hi,
I would like to find a solution where it only recognizes "COUNT" in Capital letters. At the moment it places a 1 even if there is a "count" in lower case. Is it possible to achive that with a modified formula?
=IF(ISERR(SEARCH("COUNT",B2)),FALSE,"1")
Thanks a lot
Andonny