How can I test whether a cell is in ALL CAPS in Excel?
September 23, 2004 10:25 AM Subscribe
Excel Question - Is there a way in Excel to evaluate whether a cell contains text that is in all caps as opposed to proper (first letter) caps. I know I can force cells into Upper or Proper, but I don't want to do that, i just want to flag and sort them.
This thread is closed to new comments.
=EXACT(A1,PROPER(A1))
This function will return TRUE if A1 is proper, FALSE if A1 is not.
(Reason why this works: If A1 and the "Proper" version of A1 are the same, then A1 must already be proper.) Is this similar to what you want?
posted by escher at 10:45 AM on September 23, 2004