Sorting a colum by CASE?

Greetings,
I tried a search and didn't see what I was looking for so I thought I would ask the group.

I have a spreadsheet with a column for last name and another for first name (amoung other things).

Many of the names are in ALL CAPS but not all of them. I am going to fix them using the PROPER function. I have about 50,000 records. About 6,000 need to be fixed.

I was wondering if there was a way to sort the records to group them by all the records in ALL CAPS? That way I can fix them and import them back into the database I am working on.

So my question can you sort a column based on CAPS vs. non caps like this

TEST
TEST
TEST
test
test
test

You may ask, Bradford why not just run the PROPER function on the entire sheet and then update your entire database. I could do this but the data entry was poor on teh front end and I want to spot check or eyeball teh results after the PROPER function.

Thanks in advance for your thoughts

Bradford

Thanks OldChippy!!

The ol' helper column really helped!

You run a great forumn I hope I can contribute some of my knowledge when needed.

Bradford