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" 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))