Hi,
I would like to have a macro or function that will count all the words (length >= 3) written in uppercase within a selection (such as column A). The cells contain multi-word text content, such as "The veterans on the team were SMITH, JONES, and B. HALLIDAY." That example would count as three uppercase words towards the grand total.

Thanks in advance!

Russ