|  

» Identifying the Case of Letters within Strings

Problem:

Determining whether each of the names in List1 (column A) are exclusively upper case, exclusively lower case, or a combination of both.

Solution:

Use the IF, EXACT, UPPER, and LOWER functions as shown in the following formula:
=IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case","Upper and Lower Case"))


Rate This Tip
12 34 5
Rating: 1.87     Views: 10379
Identifying the Case of Letters within Strings
Frank
This is crazy but great!
I have no idea for what purposes this can be but I love it.

Frank
Letters within String
anoop
applied very good logic.
Simple formula
Would like to see an Example
DougStroud
Would be very beneficial to see how this formula is used and what results it generated.
Just what I needed
Tim McCarthy
Thank you. This is exactly what I was looking for!!
Just what I needed
Tim McCarthy
This is exactly what I was looking for. Thanks!!
Click here to post comment
For Registered Users
Name
Comment Title
Comments