Thread: getting XL to recognize lower from upper case in IF formula
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
stef stef is offline
external usenet poster
  
Posts: 20
Default getting XL to recognize lower from upper case in IF formula
Thanks

Jim Rech wrote:
=IF(EXACT(MID(A1,3,1),LOWER(MID(A1,3,1))),"lower", "upper")

Reply With QuoteReply With Quote