Identify text in uppercase

D

David

I'm looking for a function that will identify whether a cell contains all
text characters in uppercase, returning a true value if so and a false value
if not. Does anything like this exist?
 
N

Niek Otten

Hi David,

=EXACT(A1,UPPER(A1))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
H

Harlan Grove

Gord Dibben wrote...
Vasant

You're too late.

Niek got the "awesome" tag.
Click to expand...
....

Nice to be congratulated for repeating formulas that have been around
for over a decade.

Very little in these newsgroups is original.
 
N

Niek Otten

Thank you, Harlan

Sorry I just happened to be there at the "right" time

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top