1

Even realized: =IF(A2=B2,"equals","not equals") makes no difference between higher an lower cases.

It delivers equals on comparing of example.com/Lesezeichen.html and example.com/lesezeichen.html.

Or is it an issue of german Excel?

Improve this question
1
  • No, this happens in English too! Commented Aug 9, 2019 at 13:29

1 Answer 1

Reset to default
3

What you're looking for is an Exact function which looks for the exact text including case sensitivity

=IF(exact(A2,B2),"equals","not equals")

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

means, = is good only for numeric values. Every day something new:) Thank you!
Yup learning something new. I didn't realize it because I don't really work with text too often (or as precisely), but learned about the Exact function for this, so we both learned a little bit!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.