If Cell Contains Text Then Formula in Excel helps you to produce the output when a cell have some text. You can check if cell contains some string and produce something in another cell. For Example you can check if a cell A1 contains text ‘some string’  and print Yes or No in Cell B1. Following are the example Formulas to check if Cell contains then produce some thing in a Cell.

If Cell Contains Text Then TRUE

Following is the Excel formula to return True if a Cell contains Text. You can check a cell if there is given string in the Cell and return True or False.

=IF(ISNUMBER(FIND(“How”,A1,1)),TRUE,FALSE)

The formula will return true if it found the match, returns False of no match found.

If Cell Contains Text Then TRUE

 

If Cell Contains Text Then Return a Value

We can retrn some value if cell contains some string. Here is the the the Excel formula to return a value if a Cell contains Text. You can check a cell if there is given string in the Cell and return some string or value in aother column.

If Cell Contains Text Then Return a Value

 

=IF(ISNUMBER(SEARCH(“How”,A1,1)),”Found”,”Not Found”)

The formula will return true if it found the match, returns False of no match found. can

If Cell Contains Text Then SUM

Following is the Excel formula to Sum if a Cell contains Text. You can total the cell values if there is given string in the Cell. Here is the example to sum the column B values based on the values in anoter Column.

=SUMIF($A$2:$A$7,”*”&D2&”*”,$B$2:$B$7)

The formula will Sum the values in Colum B if the cells of Column A contains the given text.

If Cell Contains Text Then SUM

 

If Cell Contains Text Then COUNT

Here is the Excel formula to Count if a Cell contains Text. You can count the number of cells containing specific text.

=COUNTIF($A$2:$A$7,”*”&D2&”*”)

The formula will Sum the values in Colum B if the cells of Column A contains the given text.

If Cell Contains Text Then COUNT