Thread: how do I get formulas to recognize case sensitive text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
  
Posts: 2,494
Default how do I get formulas to recognize case sensitive text

give an example of what you want.


=IF(LOWER(A1) = "test",1,0)


--


Gary


"okiebears" wrote in message
...
I am looking for a way to get formulas to recoginze case sensitive test


Reply With QuoteReply With Quote