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
|