| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare Upper and Lower Case
This function returns True.
=IF("asdf"="ASDF",True,False) What function do I use to get False? Thanks, James |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare Upper and Lower Case
Use the FIND function to see if one string is contained in the other -
that is case sensitive. Hope this helps. Pete Zone wrote: This function returns True. =IF("asdf"="ASDF",True,False) What function do I use to get False? Thanks, James |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare Upper and Lower Case
=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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
| Formula to identify lower case vs upper case | Excel Worksheet Functions | |||
| Upper case to Lower case | Excel Worksheet Functions | |||
| upper case to lower case | New Users to Excel | |||
| Convert lower case charecters to upper case | Excel Discussion (Misc queries) | |||
Linear Mode
