View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
u473 u473 is offline
external usenet poster
 
Posts: 184
Default 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