View Single Post
  #3   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

=EXACT(A1,UPPER(A1))

if I understand your requirements correctly.

--

Vasant


"David" wrote in message
...
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?