View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Combine: ISNUMBER(SEARCH( and EXACT( ?

Use FIND instead of SEARCH it is case sensitive


--


Regards,


Peo Sjoblom




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