View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

Hi David,

=EXACT(A1,UPPER(A1))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"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?