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.


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


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 *