wildcard search within function

  • Thread starter Thread starter sheridany
  • Start date Start date
S

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
 
Back
Top