If you want to check if a cell value (text string) contains at least one uppercase letter in excel, then use below function.
=NOT(EXACT(LOWER(A1),A1))
Note: A1 is the cell number
Above function returns
- TRUE if the cell value contains atleast one uppercase letter
- FALSE if the cell value has all lowercase letters
In the function,
LOWER(A1) converts the A1 cell value to lowercase letters
EXACT(LOWER(A1),A1)) function compares LOWER(A1) and A1 (actual string value), EXACT is case-sensitive and returns
- TRUE, if both strings are exactly equal i.e all lowercase letters
- FALSE, if they are not equal i.e. if A1 contains any capitals
Used NOT to get result TRUE if the cell value contains uppercase letter.
