Excel if function based on character not number

Occasional Visitor

If I were to return for eg '1oc' or '2oc' in a cell depending on whether this set of characters were present in a column, how would I write a formula for that

0 Replies