MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Wild card question

Posted by Andonny on February 15, 2001 3:41 PM

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?


Thanks a lot

Posted by Mark W. on February 15, 2001 3:44 PM

=EXACT("Count","COUNT") returns FALSE.

Posted by Andonny on February 16, 2001 2:06 AM

Sorry I had trouble to include it into my formula.

Thanks for your help

Posted by Aladin Akyurek on February 16, 2001 5:58 AM

Use FIND instead of SEARCH.