View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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