test for upper case

M

MusicMan

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.
 
T

Tom Hutchins

To check A1, in another cell enter

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

Copy as needed. Hope this helps,

Hutch
 
M

MusicMan

Very close, but blanks also came back true. I can handle them in IF test
though. Thanks very much.
 
D

David Biddulph

You don't, of course, need the IF(...,TRUE,FALSE), because you've already
got a Boolean.

=EXACT(A1,UPPER(A1)) will do.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
Lower-Case Characters 2
UPPER function 2
Transfer data between two tables 3
Macro to Select text from a point given to a specific word 2
Restricting Cell entry to certain letters 7
Word 2016: How do I change a REF field code that references a Heading style to Arabic when the Headi 1
Global layouts 0

Top