MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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

Hi,
Sorry I had trouble to include it into my formula.

Thanks for your help
Andonny


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


Use FIND instead of SEARCH.

Aladin