# Identifying the Case of Letters within Strings

1. ## Would like to see an Example

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

2. ## Just what I needed

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

3. ## Just what I needed

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

4. ## 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\"))

5. ## Identifying the Case of Letters within Strings

This is crazy but great!
I have no idea for what purposes this can be but I love it.

Frank

6. ## Letters within String

applied very good logic.
Simple formula

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1