Check if a cell value contains capital letter in Excel

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.