Identifying if a Text String is in Upper, Lower or Proper Case
Excel is such an incredibly powerful program! I know that you know this, but every time I think I know a lot in Excel, a situation arises which forces me to discover that there is still a lot of room to learn for me.
A few days ago I was asked by a reader that how will you identify whether a text string in Excel is in Upper, Lower or Proper case. That got me thinking a bit.
It is very easy to convert text to the case we need it to be in by using the UPPER, LOWER or PROPER functions. For this, you don’t need to check which case the text strings already are in. But what if you don’t want to make any changes, but just want to determine whether or not a text string is in upper case (or in lower or proper case for that matter).
So I thought I’d make a blog post addressing this question.
So, let’s assume that we have a column of text strings and we want to determine which of those text strings are in UPPER case. We will need to use a formula for this (the procedure would be similar if you want to determine the same for LOWER or PROPER case). And the formula is:
(assuming the relevant text is in Cell A1)
What EXACT function does is it compares two text strings and returns TRUE as the result if they are ‘exactly’ the same, otherwise it returns FALSE. EXACT function takes into account the cases the two text strings are, but not their formats.
For learning about the EXACT function in detail, I recommend you visit the relevant Microsoft Office page by clicking here.
You can paste the above formula in cell B1. What this formula will do is it will compare the text is Cell A1 to the same text in upper case. If the text in Cell A1 is in upper case the result will be TRUE, else the result will be FALSE. So, if we have text in several cells in column A, we can type in this formula right next to them in column B, and then pull the formula down to get this result for all the text strings. The text strings having TRUE as the result would be in UPPER case, and the ones having FALSE as the result would not be in UPPER case.
Similar would be the procedure to determine if a text string is in LOWER or PROPER case. You just need to substitute ‘UPPER’ with ‘LOWER’ or ‘PROPER’, as applicable.
I highly recommend you visit the above link to learn more about the EXACT function. Also, I urge you to watch the above video in which I have explained the procedure in detail with an example.
Hope you liked this article. Please post your comments below to let me know how these articles are helping you to become better at excel. I also suggest that you sign up for the Mad About Excel newsletter by simply submitting your name and email id below. It would make sure that you don’t miss out on any of the stuff posted on Mad About Excel.
See you in the next post. Thanks for reading!
GET MY EXCEL GUIDE FOR FREE
COMPLETE EXCEL FUNCTIONS AND SHORTCUTS GUIDE
Subscribe to our newsletter and get my Complete Excel Functions and Shortcuts Guide for FREE!
Thank you for subscribing.
Something went wrong.