Filter by upper case - MS Excel 2003

I have a column containing 8000 records, some of them are in upper case & rest are in proper case, is there any way wherein i can filter all records which are in upper case without using macros, i mean is it possible to do it using ISNA function ?

You could run a test on an adjacent column

=EXACT(A1,UPPER(A1))

Where TRUE you know A1 is CAPS... filter on that column.

Originally Posted by DonkeyOte

You could run a test on an adjacent column

=EXACT(A1,UPPER(A1))

Where TRUE you know A1 is CAPS... filter on that column.

It was of gr8 help.... thx for quick reply.....