View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Francis L. Kulchar Francis L. Kulchar is offline
external usenet poster
 
Posts: 27
Default Looking for the word "WIN" in a cell

Thanks...works perfectly!!

FLKulchar

--
Francis L. Kulchar
"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Try
=IF(ISERROR(FIND("win",A1)),FALSE,TRUE)

It will not match Win though...
If case is not important then you can use UPPER("win") and UPPER(A1)
=IF(ISERROR(FIND(UPPER("win"),UPPER(A1))),FALSE,TR UE)

"F. Lawrence Kulchar" wrote:

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