How to Allow Only UPPERCASE, lowercase Or Proper case Entries in Excel

Accurate data entry saves tonnes of time in data clean up & analysis. Below is how to Allow Only UPPERCASE, lowercase, Or Proper case Entries in Excel.

How it Works

The EXACT Function compares two text strings and returns TRUE if they are the same else FALSE. This is a case Sensitive function.

UPPER function converts all the text characters in a string to uppercase

=EXACT(D5, UPPER(D5)) Checks if the string keyed in cell D5 is the same as the its equivalent Uppercased version.

All TRUE cases are regarded as valid while the FALSE cases are rejected as Invalid

This is repeated with the PROPER & LOWER functions test

Print Friendly, PDF & Email

Do you want to excel in Excel?


Seeking Microsoft Certification?

Every Week Receive Resources To Get you Closer to Your Goal!

No Huff! No Fluff! No Spam!

You are on your way to Excelling in Excel and Becoming Microsoft Certified!

Share This

Spread the Good News!

Do me favour, please? Share this with your friends!

Thanks For Commenting!

Awesome for you to comment! Please share the post with your friends.