I've got a spreadsheet with 600,000 email addresses in one column. Some of these email addresses are in CAPS some start with a Capital letter.

What I want to do is to identify ALL of the rows that contain a capital letter with (eg) "yes" in column C.

That way I can sort by this column, remove the No's, convert the remainder to lowercase and import back into the CRM system. I don't want to convert everything in the database as I'll then have to re-import all 600,000 records - not a small job!

Any help would be appreciated - thanks.