View Single Post
  #4   Report Post  
Alan
 
Posts: n/a
Default

Nice one Niek,
Regards,
"Niek Otten" wrote in message
...
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?