Identify text in uppercase
 

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

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

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

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?

You're awesome. Thanks!

"Niek Otten" wrote:

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?

Vasant

You're too late.

Niek got the "awesome" tag.


Gord

On Tue, 3 May 2005 13:30:24 -0400, "Vasant Nanavati" <vasantn *AT* aol *DOT*
com wrote:

=EXACT(A1,UPPER(A1))

if I understand your requirements correctly.

Gord Dibben wrote...
Vasant

You're too late.

Niek got the "awesome" tag.
....

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

Very little in these newsgroups is original.

Darn, I'm always just missing the accolades! :(

--

Vasant

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Vasant

You're too late.

Niek got the "awesome" tag.


Gord

On Tue, 3 May 2005 13:30:24 -0400, "Vasant Nanavati" <vasantn *AT* aol
*DOT*
com wrote:

=EXACT(A1,UPPER(A1))

if I understand your requirements correctly.

Thank you, Harlan

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Harlan Grove" wrote in message
ups.com...
Gord Dibben wrote...
Vasant

You're too late.

Niek got the "awesome" tag.
...

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

Very little in these newsgroups is original.