How To Identify If A Text String Is In Upper, Lower Or Proper Case

Published on January 19, 2017

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.exact function

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:

=EXACT(A1,UPPER(A1))

(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.

HUGE LIMITED TIME DISCOUNT ON THE BEST ADVANCED EXCEL COURSE ENROLL NOW!!
EXCEL PRINT TIPS
9 Excel Print Settings You Probably Don’t Know About
excel_look_professional
Making Excel Worksheets Look Professional – A Case Study
14 Excel tips
14 Excel Tips – Make Yourself Super-Efficient in Excel
DATA CLEANING EXCEL
Ultimate Guide to Data Cleaning in Excel – 11 Super-Powerful Data Cleaning Techniques
FREEZE PANES
Freeze Panes in Excel – The Complete Guide
HOW TO LEARN EXCEL
How to Learn Excel and Be a Spreadsheet Champion
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
BECOME AN EXCEL NINJA COMPLETE REVIEW
Become An Excel Ninja – Course Review
BEST EXCEL COURSES
10 Best Online Courses to Make You an Excel Wizard
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
How to Sort Excel Worksheet in Alphabetical Order
How to Sort Excel Worksheets in Alphabetical Order
VBAPOST1
How to Add And Name A New Sheet At The Same Time Using Excel VBA
ROUNDING NUMBERS IN EXCEL
Rounding Numbers in Excel – The Complete Guide
number_of_words
How to Find the Number of Words in a Text String in Excel
HOW TO FIND IF A TEXT STRING CONTAINS SPECIFIC TEXT IN EXCEL
How to Find if a Text String Contains Specific Text in Excel
How To Indentify ULP case in a text string
How To Identify If A Text String Is In Upper, Lower Or Proper Case
Pivot Tables
How to Insert a Pivot Table in Excel – Pivot Table Basics
How To Convert Pivot Table Into Frequency Distribution
How to Convert Pivot Table into a Frequency Distribution in Excel

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.

Share
Tweet
+1
Pin
Share
Stumble
Enjoyed this video?
How To Indentify ULP case in a text string
"No Thanks. Please Close This Box!"