test for upper case
You don't, of course, need the IF(...,TRUE,FALSE), because you've already
got a Boolean.
=EXACT(A1,UPPER(A1)) will do.
--
David Biddulph
"Tom Hutchins" wrote in message
...
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.
|