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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> Hi David,
>
> =EXACT(A1,UPPER(A1))
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "David" <[email protected]> wrote in message
> news:[email protected]...
>> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>