Forum Discussion
Formula to find a string
Hello! I'm struggling with something that seems simple. I'm trying to wrote a formula that looks for a specific string in a cell: "Appointment of Rep". The cell can contain many things, below ...
Assuming your string is in cell A2, then you may try one of the below formulas...
=IF(ISNUMBER(SEARCH("Appointment of Rep",A2)),"True","False")
OR
=IF(ISNUMBER(FIND("Appointment of Rep",A2)),"True","False")
OR
=IF(COUNTIF(A2,"*Appointment of Rep*"),"True","False")