View Single Post
  #1   Report Post  
bob
 
Posts: n/a
Default 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.