Thread: [Solved] * Determine Capitalization
View Single Post
 
Old 05-03-2011, 10:52 AM
djreyrey djreyrey is offline Windows 7 Office 2007
Novice
  
Join Date: Mar 2010
Posts: 21
djreyrey is on a distinguished road
Default
I just found exactly what I was looking for. Here's the formula:

=IF(EXACT(B4,LOWER(B4)),"Lower Case","")

All I needed to know was which ID's in Column B where lower case.

Thanks for your efforts!
Reply With Quote