ExcelBanter - Compare Upper and Lower Case

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Compare Upper and Lower Case (https://www.excelbanter.com/excel-discussion-misc-queries/112625-compare-upper-lower-case.html)

Zone

Compare Upper and Lower Case

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

Pete_UK

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

ImpulseBlue

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

Zone

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

All times are GMT +1. The time now is 04:53 PM.