Combine: ISNUMBER(SEARCH( and EXACT( ?

Combine: ISNUMBER(SEARCH( and EXACT( ?

Post by bmFzdGVja » Wed, 19 Sep 2007 02:14:04


Hi, trying to combine these two items, have the following that does not seem
to work, thanks.

=ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))
 
 
 

Combine: ISNUMBER(SEARCH( and EXACT( ?

Post by Ron Coderr » Wed, 19 Sep 2007 02:27:24

Just guessing......
If you want to know if cell CI9 contains the word Test,

Try this:
=COUNTIF(CI9,"*Test*")>0
or this
=ISNUMBER(SEARCH("Test",CI9))

But, if you need a case-sensitive search:
=ISNUMBER(FIND("Test",CI9))

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

 
 
 

Combine: ISNUMBER(SEARCH( and EXACT( ?

Post by Peo Sjoblo » Wed, 19 Sep 2007 02:28:05

Use FIND instead of SEARCH it is case sensitive


--


Regards,


Peo Sjoblom
 
 
 

Combine: ISNUMBER(SEARCH( and EXACT( ?

Post by Bernard Li » Wed, 19 Sep 2007 02:33:35

Not really surprising.
EXACT returns either TRUE or FALSE

So past of your formula will be SEARCH(TRUE,C19)
(or SEARCH(FALSE,C19) )
but the syntax is SEARCH(find_text,within_text,start_num)

Please tell us what you wish to achieve.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
 
 
 

Combine: ISNUMBER(SEARCH( and EXACT( ?

Post by bmFzdGVja » Wed, 19 Sep 2007 02:48:01

case-sensitive text, within text