detect upper/lower case

  • Thread starter Thread starter mike allen
  • Start date Start date
M

mike allen

i need to tell if a letter is capital or lower case. ex: cell A1=Minn and
cell B2 needs to output "upper" or "lower" referencing the first letter
("M"). thus B2 should read "upper."

i have tried variations of the functions upper and lower, but to no avail.
any thoughts? thanks, mike allen
 
Hi Mike
one way:
=IF(CODE(LEFT(A1,1))>=65,"Upper","Lower")

Note: This does work for letters A-Z, a-z but not for characters like
'ö', 'Ö'
 
A formula. The question is WHY? you want this.

=IF(EXACT(LEFT(A1),UPPER(LEFT(A1))),"upper","lower")
 
Back
Top