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

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

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" <(E-Mail Removed)> wrote in message
news:BD5D22D9-7FC5-4F2E-8246-(E-Mail Removed)...
> Hi, trying to combine these two items, have the following that does not
> seem
> to work, thanks.
>
> =ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))

Use FIND instead of SEARCH it is case sensitive


--


Regards,


Peo Sjoblom




"nastech" <(E-Mail Removed)> wrote in message
news:BD5D22D9-7FC5-4F2E-8246-(E-Mail Removed)...
> Hi, trying to combine these two items, have the following that does not
> seem
> to work, thanks.
>
> =ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))

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

"nastech" <(E-Mail Removed)> wrote in message
news:BD5D22D9-7FC5-4F2E-8246-(E-Mail Removed)...
> Hi, trying to combine these two items, have the following that does not
> seem
> to work, thanks.
>
> =ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))

case-sensitive text, within text

"Bernard Liengme" wrote:

> 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
>
> "nastech" <(E-Mail Removed)> wrote in message
> news:BD5D22D9-7FC5-4F2E-8246-(E-Mail Removed)...
> > Hi, trying to combine these two items, have the following that does not
> > seem
> > to work, thanks.
> >
> > =ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))
>
>
>