Thread: Identifying the Case of Letters within Strings

Would be very beneficial to see how this formula is used and what results it generated.

Thank you. This is exactly what I was looking for!!

This is exactly what I was looking for. Thanks!!

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\"))

applied very good logic.
Simple formula