| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Cell Contains specific UPPERCASE text
Thank you both! worked great.
"Glenn" wrote: GoBucks wrote: 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)) SEARCH is not case sensitive. FIND is: =ISNUMBER(FIND("LOA",A4)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible to distinguish uppercase from lowercase text? | Excel Discussion (Misc queries) | |||
| making all text into uppercase | Excel Discussion (Misc queries) | |||
| Search on uppercase text | Excel Discussion (Misc queries) | |||
| Identify text in uppercase | Excel Worksheet Functions | |||
| Automatically change text to uppercase | Excel Worksheet Functions | |||
![GoBucks[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
