How to identify uppercase, lowercases, and proper cases in Excel?
Sometimes there may be many uppercases, lowercase, or proper cases mixing in a range. Normally it is not easy to identify the cells with uppercase, lowercase, or proper cases by eyes quickly. And here we will introduce some easy ways to identify cells with uppercase, lowercase, and proper case quickly.
Kutools for Excel’s Select Duplicate & Unique Cells can help you quickly select and highlight the duplicate values or unique values that are case sensitive in a range of worksheet, and then you can remove them at once.
We will show you the guidance to identify all uppercase, lowercases, and proper cases with the following table.
You can identify all cells with uppercases in a selection with following steps:
1. In a blank cell, says Cell C1, enter the formula of =EXACT(B1,UPPER(B1)), and press the Enter key.
This formula will identify whether the text in Cell B1 is uppercase or not. If the text in Cell B1 is uppercase, it will returns "TRUE"; if the text in Cell B1 is not uppercase, it will returns "FALSE".
2. Select the Range of C1:C20, and click the Home > Fill > Down to copy the formula to each cell. Now you can identify the uppercase in Column B according to the values in Column C easily.
You can identity all cells with lowercase in selection with following steps:
1. In a blank cell, says Cell C1, enter the formula of =EXACT(B1,LOWER(B1)), and press the Enter key.
2. Select the cell C1, and drag the fill handle over the range of cells that you want to contain this formula. Now it fills the Column C with the text of "TRUE" and "FALSE". The text of "TRUE" means the text in corresponding cell in Column B is lowercase, and the text of "FALSE" means it is not lowercase.
You can use this formula =EXACT(B1,PROPER(B1)) or =SUBSTITUTE(B1,PROPER(B1),"x")="x" to identify if the text in specific cell is proper case or not.
That will also return False if the original string (in B1) is not in the proper case, and True if it is. See screenshots:
Excel Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 months agoHow to search in text for example Hellohall and separate small and big capital in our case Hallo hall?
To post as a guest, your comment is unpublished.· 2 years agoanyway that =EXACT(B1,PROPER(B1)) can ignore apostrophes?
i am getting a false return on : McDonald's
if i change it to McDonald'S - it returns true, which is not what I am looking for
To post as a guest, your comment is unpublished.· 3 years agoThanks for your supporting.
To post as a guest, your comment is unpublished.· 3 years agoHow to identity capital letter between both cells A1 A2
A1 Cell - Kavith is Going to Home
A2 Cell - kavith is going to home
How to find A2 is properly as A1cell or not.
To post as a guest, your comment is unpublished.· 3 years agohoe to identity a capital letter in a cell in excel like aabId=I, manOj= O