Search code examples
regexgoogle-sheetsarray-formulasuppercaselowercase

Google Sheet comparative uppercase and lowercase

I need to check the contents of a cell to make sure that all characters in it are uppercase, but comparative "=" (=UPPER(cell)=cell, doesn't work.

"Abc" = "ABC" => TRUE

"abc" = "ABC" => TRUE

Solution

  • You can use

    =EXACT(A1,B1)

    which will compare the case as well.