wildcard search within function

[sheridany]

I have a column that needs to be populated with either
a "B" or "C" based on conditional logic using an IF
function.

Column A contains text fields and I am searching for any
word "Business" within the text . If it finds the word,
the logical outcome in Column B is "B" otherwise it is C.

The problem with Column A is the word "business" may be at
the beginning, middle or end of the text. A wildcard such
as * ~? or ? is not working.

Example to populate Column B.

Column A Column B
Business
Banking B
Consumer
Banking C
ATM Business
Card B

 

[Frank Kabel]

Hi
try the following in B1
=IF(ISERROR(FIND("Business",A1)),"C","B")

HTh
Frank