Hello,

I've seen different variations of this on the forum but when I try to use what has been suggested it won't work. I need a formula that will return the number 1 if a cell contains a specific text. The cells would contain:

Smith, AB1
or
Doe, AB1

I need it to look for "AB1"

Thanks again for everyone's help.