Excel: Contains - how to check the contents of cells

Tables and lists can be easily edited and customized in Excel. There are numerous functions available for this purpose. If you want to check the contents of a cell for a specific text, then this is possible with various functions. There are various "Contains" functions for this.

How to apply a "Contains" function in Excel

If you want to check in Excel whether a cell contains a certain text, there are several functions available. You don't always have to use a formula to do this. To search the entire spreadsheet for a keyword, first select the area where you want to search. If you want to search the whole document, click somewhere in an empty field. Then select "Start" and under "Edit" select the "Select & Search" button. Enter the term and confirm with "Enter". If you want to check certain cells for different contents, you can use a formula.

1. Use the "IsText" function to check whether a cell contains a text. The output can be "TRUE" or "FALSE." However, this function cannot be used to test for a specific text.
2. To test for a specific text, use the "IF" function. This way it is possible to also determine the output of the query.
3. For example, if you want to check a cell to see if it contains the word "apple", then write "IF(A1="apple"; "TRUE"; "FALSE")".
4. So the formula checks: if cell A1 contains the word "apple", then output the word "TRUE", if not, then "FALSE".