If Cell Contains specific UPPERCASE text

  • Thread starter Thread starter GoBucks
  • Start date Start date
G

GoBucks

I'm trying to write a fomula that will look in column A for any text that
contains the text "LOA". If TRUE, I want to apply some conditional formatting
to a range of cells. I tried the following formula when A4 = "loa" and it
still comes up TRUE. Any suggestions?

=ISNUMBER(SEARCH(UPPER("LOA"),A4))
 
GoBucks said:
I'm trying to write a fomula that will look in column A for any text that
contains the text "LOA". If TRUE, I want to apply some conditional formatting
to a range of cells. I tried the following formula when A4 = "loa" and it
still comes up TRUE. Any suggestions?

=ISNUMBER(SEARCH(UPPER("LOA"),A4))
Click to expand...


SEARCH is not case sensitive. FIND is:

=ISNUMBER(FIND("LOA",A4))
 
GoBucks said:
I'm trying to write a fomula that will look in column A for any text that
contains the text "LOA". If TRUE, I want to apply some conditional formatting
to a range of cells. I tried the following formula when A4 = "loa" and it
still comes up TRUE. Any suggestions?

=ISNUMBER(SEARCH(UPPER("LOA"),A4))
Click to expand...


SEARCH is not case sensitive. FIND is:

=ISNUMBER(FIND("LOA",A4))
 
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.
 
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.
 
Back
Top