View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Zone Zone is offline
external usenet poster
 
Posts: 269
Default Compare Upper and Lower Case

Thank you for your replies, Impulse and Pete. Exact seems to do
"exactly" what I want!
James
ImpulseBlue wrote:
=EXACT("asdf","ASDF")

EXACT is case sensitive


Zone wrote:
This function returns True.
=IF("asdf"="ASDF",True,False)
What function do I use to get False?
Thanks, James