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?
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?
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?
>
>
>
=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?
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.
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.
>
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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks