Try something like this, assuming you are using column A for your
entries:

=IF(LEN(A1)=1,IF(AND(CODE(UPPER(A1))64,CODE(UPPER (A1))<91),"condition
met",""),"")

adapt the "condition met" message to suit what it is you want to do.
This will check for A to Z and a to z in A1 - remove the UPPER( ) from
the formula to only allow A to Z.

Hope this helps.

Pete

JamesBurrows wrote:
Sorry I will try to clarify this.

I have a colum which may look something like this

A
{blank cell}
B
{blank cell}
Today is the Day
{blank cell}
{blank cell}
A
{blank cell}
|I woke up this morning
D

and I want the If loop to be able to say if = (A-Z) IE if it finds a
cell with a single letter in it ie A to Z then......

Hope this helps


--
JamesBurrows
------------------------------------------------------------------------
JamesBurrows's Profile: http://www.excelforum.com/member.php...o&userid=35101
View this thread: http://www.excelforum.com/showthread...hreadid=549445