Sorting based on Capitalization in cell

mhp620

New Member
Joined
Jan 6, 2010
Messages
25
Hi. I have an Excel sheet with many thousands of names. The names are in various capitalization formats:

1. Some names are all lower case
2. some all upper case
3. some with the first letters capitalize

Is there a way to sort these by the three formats? I don't want to change them. I just need to tag them by their format.

Thanks in advance. mike
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,309
Assuming that A2:A1000 contains the data, try...

B2, copied down:

=IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case",IF(EXACT(A2,PROPER(A2)),"Proper Case","Other")))
 

Watch MrExcel Video

Forum statistics

Threads
1,109,541
Messages
5,529,437
Members
409,877
Latest member
DDhol
Top