If I have a group of cells that have different text strings in them (differing in length as well), is there any easy way to write a formula that will tell if the cells have a certain word at any point in the string?
i.e. if I am looking to flag any cells with the word "exempt" in them, how could you write a formula that would pick up if "exempt" were in the beginning, end, or somewhere in the middle of the cell?
Thanks,
Nick
Bookmarks