View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
Posts: 84
Default Lower-Case Characters

I am using Excel 2007 on a Windows 7 PC.

I have a long Excel list of part numbers with their description. The
company rule states that the description for each part number must be
all in upper case alphabetical characters, but some are not. How would
I quickly flag which parts have descriptions that do not fit the rule?

To clarify: If the description is _all_ in upper case alphabetical
characters (with the exception of digits or special characters, of
course!) then the rule is met. If the description is in lower case
characters (even if it is only one lower case alphabet character within
the string) then the rule is not met.

Thanks.
--
tb