If Cell Contains specific UPPERCASE text

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))
 
G

Glenn

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))
 
A

AG

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Conditional Formatting Formula 3
Excel Formula - If Cell contains word and select it from a list? 0
=MATCH with nested arrays assistance needed 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
How To Lookup a full row if it contain a text in a spec coloumn from diffrent sheet? 1
Cell Range Split into Multiple Cells 6
Return a value if a range of cells contain text 2

Top