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
















[TABLE="width: 508"]
<tbody>[TR]
[TD]CREATE SESSION No[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AMITIB_WRITE YES[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AMI_READWRITE YES[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AWD_TIBREADWRITE YES[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CONNECT No[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CORP_SECURITY_RW YES[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DBA_RW YES

Can anyone please advise how to do this?
Thank you[/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col span="2"></colgroup>[/TABLE]

 

[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.