Excel if function based on character not number

%3CLINGO-SUB%20id%3D%22lingo-sub-2275196%22%20slang%3D%22en-US%22%3EExcel%20if%20function%20based%20on%20character%20not%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2275196%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I%20were%20to%20return%20for%20eg%20'1oc'%20or%20'2oc'%20in%20a%20cell%20depending%20on%20whether%20this%20set%20of%20characters%20were%20present%20in%20a%20column%2C%20how%20would%20I%20write%20a%20formula%20for%20that%3C%2FP%3E%3C%2FLINGO-BODY%3E
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