Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Minor puzzle: some UDF calls respect mixed case, others insist on lower case | Excel Programming | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
Help w/ project. Counting upper and lower case characters in a cell. | Excel Programming | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) |