Hi GoBucks,

Because FIND is case sensitive, that is precisely why I have used:

=ISNUMBER(FIND("LOA",UPPER(A4),1))

It does not matter whether A4 contains loa or Loa of loA or lOa ...
upper of that will always make is "LOA", which is why you will be able
to find "LOA" in UPPER(A4). As long as loa exists in cell A4 in some
form the FIND("LOA",UPPER(A4),1) will always return a number.