G
Guest
Hi, trying to combine these two items, have the following that does not seem
to work, thanks.
=ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))
to work, thanks.
=ISNUMBER(SEARCH(EXACT(CI9,"Test"),CI9))
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Coderre
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)
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)
P
Peo Sjoblom
Use FIND instead of SEARCH it is case sensitive
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
B
Bernard Liengme
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
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
G
Guest
case-sensitive text, within text
Bernard Liengme said: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