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

excel-function-to-check-cell-contains-capital-letter

 

 

 

 

 

 

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

Leave a Reply

Your email address will not be published. Required fields are marked *