Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» 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: 8739
Identifying the Case of Letters within Strings
Frank wrote on October 28, 2005 03:24 EST
This is crazy but great!
I have no idea for what purposes this can be but I love it.

Frank
Letters within String
anoop wrote on October 28, 2005 23:35 EST
applied very good logic.
Simple formula
Would like to see an Example
DougStroud wrote on December 31, 1969 19:00 EST
Would be very beneficial to see how this formula is used and what results it generated.
Just what I needed
Tim McCarthy wrote on December 31, 1969 19:00 EST
Thank you. This is exactly what I was looking for!!
Just what I needed
Tim McCarthy wrote on December 31, 1969 19:00 EST
This is exactly what I was looking for. Thanks!!



REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation