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.
Identify all cells with UPPERCASE in selection in Excel
Identify all cells with lowercase in selection in Excel
Identify all cells with Proper Case in selection in Excel
We will show you the guidance to identify all uppercase, lowercases, and proper cases with the following table.
Convert text strings to uppercase, lowercase, proper case or sentence case: With the help of Kutools for Excel’s Change Case utility, you can quickly change the text strings to upper case, lower case, proper case, sentence case and so on.
|
Identify all cells with UPPERCASE in selection in Excel
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.
Identify all cells with lowercase in selection in Excel
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.
Identify all cells with Proper Case in selection in Excel
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:
 |
 |
 |
Unlock Excel Magic with Kutools AI
- Smart Execution: Perform cell operations, analyze data, and create charts—all driven by simple commands.
- Custom Formulas: Generate tailored formulas to streamline your workflows.
- VBA Coding: Write and implement VBA code effortlessly.
- Formula Interpretation: Understand complex formulas with ease.
- Text Translation: Break language barriers within your spreadsheets.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in