Well I'll be darned. You are right... Text... Shows how close I was watching.
In the future I'll not question your infintite wisdom. (I'll leave that to
your girls. They apparently have more practice anyway).

"Bob Phillips" wrote:

Because the OP used text in her original mail (terrible reason I know, but I
wasn't up for questioning it :-)).

Mine girls are grown up Jim, so they blame me. Believe me, the fun is
gone:-)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jim Thomlinson" wrote in message
...
Bob... Why return the 1 and 0 as text. And are you insinuating that we
shouldn't blame our kids. That takes half the fun out of having them. :)

"Bob Phillips" wrote:



"Ann" wrote in message
...
Really sorry..

My daughter just pressed the enter key!!

A likely story :-)

... what I was saying is that the three letter sequence
may be anywhere in the cell.


=IF(AND(ISNA(B1),OR(ISNUMBER(FIND("stw",D2)),ISNUM BER(FIND("iwo",D2)))),"1",
"0")