Compare cell contents against string in Excel - Stack Overflow

Consider the following: A B 1 ENG 1 2 ENG 1 3 FRA 0 4 FOO 0. I need a formula to populate the B column with 1 if the A column contains the string ENG , or 0 ...

stackoverflow.com