Finding a string in a cell

[Stan Lieberman]

Hello - I need to search a cell for two strings. If either of the two strings is found insert "YES" in the formula cell; if not, insert "No". Example:
If "WRITE" or "RW" is found in column A, insert "YES" in column B, else insert "No"

Column A Column B

CREATE SESSION No
AMITIB_WRITE YES
AMI_READWRITE YES
AWD_TIBREADWRITE YES
CONNECT No
CORP_SECURITY_RW YES
DBA_RW YES Can anyone please advise how to do this? Thank you

<tbody>
</tbody><colgroup><col span="2"></colgroup>

 

[Michael M]

Try

=IF(OR(ISNUMBER(SEARCH("*RW*",A1)),ISNUMBER(SEARCH("*Write*",A1))),"Yes","No")

 

[Stan Lieberman]

Thank you, Michael. Just what I was looking for.