Try this in A2

=IF(LEFT(A1,1)="A","Yes","")

Mike

"mahmad" wrote:

Hi,

I want to be able to find if a particular cell which contains a specific
letter and if it does then say yes in another cell. I am using Excel 03.

for example.

cell a1 = ABC (i am interesed in letter A) as this cell includes letter i
want a YES in cell a2.

thanks

Mo