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.
posted by willnot to Computers & Internet (2 answers total) 1 user marked this as a favorite
 
Yes and No. Yes, there is a simple test to figure out if a cell contains Proper text or not. No, i'm not sure if you'll be able to use it to help you sort items. To test if Cell A1 is proper or not:

=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


That worked great. Thanks.
posted by willnot at 11:29 AM on September 23, 2004


« Older Typesetting   |   good, small, inexpensive, energy-efficient space... Newer »
This thread is closed to new comments.