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 otherwise I ve tried in cell B1 IF A1 TEXT ENG FALSE 1 0 but then it says NAME in the cell Putting ENG between quotation marks doesn t help either What should my formula be like

If a case-insensitive comparison is acceptable just use IF A1 ENG 1 0

[string] Compare cell contents against string in Excel

You can use the EXACT Function for exact string comparisons.

=IF(EXACT(A1, "ENG"), 1, 0)

• How to split a string in two and store it in a field • String method cannot be found in a main class method • Kotlin - How to correctly concatenate a String • Replacing a character from a certain index • Remove quotes from String in Python • Detect whether a Python string is a number or a letter • How does String substring work in Swift • How does String.Index work in Swift • swift 3.0 Data to String? • How to parse JSON string in Typescript

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

• How to use *ngIf else? • SQL Server IF EXISTS THEN 1 ELSE 2 • What is a good practice to check if an environmental variable exists or not? • Using OR operator in a jquery if statement • R multiple conditions in if statement • Syntax for an If statement using a boolean • How to have multiple conditions for one if statement in python • Ifelse statement in R with multiple conditions • If strings starts with in PowerShell • Multiple conditions in an IF statement in Excel VBA

• Wildcard string comparison in Javascript • How to compare two JSON objects with the same elements in a different order equal? • Comparing strings, c++ • Char Comparison in C • bash string compare to multiple correct values • Comparing two hashmaps for equal values and same key sets? • Comparing boxed Long values 127 and 128 • Compare two files report difference in python • How do I fix this "TypeError: 'str' object is not callable" error? • Compare cell contents against string in Excel