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.

#### About the Author

#### SRINI S

A passionate blogger. Love to share solutions and best practices on wordpress hosting, issues and fixes, excel VBA macros and other apps