Help w/ project. Counting upper and lower case characters in a cell.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Here's the task I'm trying to complete:

Take text from a cell.
Count all uppercase letters.
Count all lower case letters.

I've figured out how to count the total letters excluding spaces using
the LEN and SUBSTITUTE commands, but I'm stuck on how to count how many
uppercase and lower case letters there are. Can anyone point me in the
right direction?

.

Relevant Pages

  • Re: Lowercase equivalent to uppercase, or vice versa
    ... Consider that age 28 is equivalent to adult, ... (Though Russell is said to have claimed that mathematics ... letters, depending on context; while uppercase letters ...
    (comp.lang.cobol)
  • Woody XFree86-4.3 Symbol font problem
    ... Symbol font is all screwed up. ... Lowercase letters are rendered as uppercase letters, ... Robert Knop ...
    (Debian-User)
  • Re: Lowercase equivalent to uppercase, or vice versa
    ... The set of natural numbers is NOT in a one to one correspondance with the set {baby, child, teen, adult, senior}, so the term "equivalent" here is not being used in the mathematical sense. ... letters, depending on context; while uppercase letters ...
    (comp.lang.cobol)
  • Re: ULTIMATE UGLIEST PINBALL MACHINE????? AND THE PRETTIEST ?????
    ... its easier to read big letters.. ... Lowercase letters have shape information--tall, short, thin, wide, and some ... There is folklore about how uppercase letters got the upper hand at the ... Mr. Pinball Classified--More Pinball Ads than ANYWHERE, ...
    (rec.games.pinball)
  • RE: IF Statment more than 7 stacked ?
    ... Insert a column just beside column B and enter a list of all your letters ... starting in C2 then in the cell where you want the formula enter ... Excel 2003 ... As you can see im stuck at "H" ...
    (microsoft.public.excel.misc)