Hi Dusty,

Am Fri, 19 Oct 2012 13:53:09 +0000 schrieb DustyT:

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.

the formula will give you a TRUE or FALSE for the first letter of the
email address:
=AND(CODE(LEFT(B1,1))64,CODE(LEFT(B1,1))<91)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2