Identify text in uppercase

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi David,

=EXACT(A1,UPPER(A1))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
=EXACT(A1,UPPER(A1))

if I understand your requirements correctly.
 
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.
 
Thank you, Harlan

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
You must log in or register to reply here.

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

Find the UPPERCASE letter in a string 9
Why do Excel functions return the text and not run? 1
Searching Uppercase characters 1
Convert to uppercase 1
lookup 4
Return the value from one range that does not exist in another 0
can you ensure that all text entry is in uppercase 15
Automatically change text to uppercase 2

Back
Top