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)


"nastech" wrote in message
...
Hi, trying to combine these two items, have the following that does not
seem
to work, thanks.

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