LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Minor puzzle: some UDF calls respect mixed case, others insist on lower case Prof Wonmug Excel Programming 5 May 1st 10 12:32 AM
Changing multiple cell text from lower case to upper case Patti Excel Discussion (Misc queries) 2 January 4th 08 08:35 PM
Changing upper case characters to upper/lower Richard Zignego Excel Discussion (Misc queries) 1 December 17th 07 10:09 PM
Help w/ project. Counting upper and lower case characters in a cell. [email protected] Excel Programming 1 March 18th 06 12:06 AM
Change the text from lower case to upper case in an Excel work boo dave01968 Excel Discussion (Misc queries) 2 December 9th 05 09:09 AM


All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"