Save content
Have you found this content useful? Use the button above to save it to your profile.

Excel Tip: When case matters...

8th Apr 2014
Save content
Have you found this content useful? Use the button above to save it to your profile.

Upper Lower CaseFrom the Not Just Numbers blog:

Just a very short tip for this week.

Do you ever have a situation where you need to compare two values but you don't want to treat them as the same if one is upper case and the other is lower case?

As far as Excel is concerned, "A"="a"!

Fortunately, there is a function in Excel that can help.

The EXACT function allows you to compare two values and returns TRUE if they are EXACTLY the same, including case.

So,

where

=IF("A"="a","The same","Different")

returns "The same"

=IF(EXACT("A","a"),"The same","Different")

returns "Different"

That's it! Simple, but handy if you need it.

Excel Expert Course

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "The 5 Excel features that you NEED to know" and "30 Chants for Better Charts".

Tags:

You might also be interested in

Replies (0)

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.