Finding Partial Text in a Cell
I want to check a cell for the word "Total." The cell contains additional
text before the word Total. If the Total is found, I want to populate the
cell containing the formula with 1. If not, populate it with 0.
What is the formula for this?
The IF fundtion doesn't seem to include a way to find partial text strings.
|