| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to FIND lowercase or uppercase of target occurence
My bible says the FIND function does not distinguish between case as
opposed to SEARCH. I wanted to be flagged for the word FREIGHT embedded in a text cell, but the following formula did not respond for lowercase Freight. Where did I go wrong ? I am using Excel 2007. =IF(ISERROR(FIND("FREIGHT",V91)),"","F") Thank you, Celeste |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing uppercase to lowercase | Excel Discussion (Misc queries) | |||
| How do I do a global change from uppercase to lowercase? | Excel Discussion (Misc queries) | |||
| uppercase to lowercase | Excel Worksheet Functions | |||
| lowercase to uppercase | Excel Worksheet Functions | |||
| uppercase to lowercase | Excel Discussion (Misc queries) | |||
Threaded Mode
