Looking for the word "WIN" in a cell
Based on your samples:
All on one line. Split so that line wrap won't take out any of the space
characters in the formula.
=ISNUMBER(SEARCH(" win "," "
&SUBSTITUTE(A2,","," ")&" "))
--
Biff
Microsoft Excel MVP
"F. Lawrence Kulchar" wrote in
message ...
Now van I test for a true-false issue in a cell containing the word
'WIN'??
For example, the followinh cells would provide the following vresults;
win, P1 TRUE
P2, Pa3 FALSE
P4,KING, win TRUE
Tr,win,dr,win,lose TRUE
Lose, Lose, Winfield FASLSE
Lose, Lose, Winfield FALSE
Thanks, FLKulch
|