To check A1, in another cell enter

=IF(EXACT(A1,UPPER(A1)),TRUE,FALSE)

Copy as needed. Hope this helps,

Hutch

"MusicMan" wrote:

Is their a function or way to use the UPPER function to test if the contents
on a cell are all Upper case?

Alternatively if someone has a macro to do so I could copy I would appreciate.