» Identifying the Case of Letters within Strings
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
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"))
Book Store:
Recommended Books:
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!!
I have no idea for what purposes this can be but I love it.
Frank