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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to FIND lowercase or uppercase of target occurence
Try
=IF(ISERROR(FIND("FREIGHT",UPPER(D6))),"","F") Mike "u473" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to FIND lowercase or uppercase of target occurence
use for any
freight FREIGHT fREIGhT Freight =IF(ISERROR(SEARCH("FREIGHT",C1)),"","F") -- Don Guillett Microsoft MVP Excel SalesAid Software "u473" wrote in message oups.com... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to FIND lowercase or uppercase of target occurence
Find IS case-sensitive - use SEARCH instead of FIND if you want to be
independent of case. Alternatively, you could amend your formula to this: =IF(ISERROR(FIND("FREIGHT",UPPER(V91))),"","F") Hope this helps. Pete On Aug 23, 10:41 pm, u473 wrote: 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 |
Reply |
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) |