View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
laralea laralea is offline
external usenet poster
 
Posts: 12
Default Formula to identify lower case vs upper case

(A2)=IF(ISNUMBER(SEARCH("n",W2)),"Y")

THIS WILL PUT A "Y" IN CELL A2 IF THERE IN AN "n" (upper or lower case) in
cell W2.
I need it to put a Y in cell AS only if there is a lower case n in cell W2.
This is Excel 2003

Thanks for the help!