To check if a cell contains specific text, use ISNUMBER and SEARCH in Excel. There is no CONTAINS function in Excel.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Check cell containing text in Excel
1. To find the position of a substring in a text string, use the SEARCH function.
2. The ISNUMBER function returns TRUE if the cell contains a number and FALSE otherwise.
3. You can also check if a cell contains specific text.
4. To perform a case-sensitive search, replace the SEARCH function with the FIND function.
5. Add the IF function. The formula below (case insensitive) returns “Found” if a cell contains specific text and “Not Found” otherwise.
6. You can also use IF and COUNTIF in Excel to check if a cell contains specific text. However, the COUNTIF function is not case sensitive.
In addition, you can also view many other excel articles here.
