Variation of my second formula:

IF(OR(ISNUMBER(SEARCH("A",A1)),ISNUMBER(SEARCH("B" ,A1)),
ISNUMBER(SEARCH("C",A1))),"blue","")

If you meant that you want to colour the cell blue, then you would
need to do this with Conditional Formatting.

Hope this helps.

Pete

On Oct 2, 1:51*pm, mahmad wrote:
thanks for your help guys, *I want to expand the idea a little further.

If cell A1 = ABCD

I would like to output in another cell to something different depending on
the letter.

e.g.

A1 = ABCD * * if A or B or C then * blue

thanks



"Pete_UK" wrote:
Try this:

=IF(UPPER(LEFT(A1,1))="A","yes","no")

to check for the first character, or this:

=IF(ISNUMBER(SEARCH("A",A1)),"yes","no")

to check anywhere in A1. Of course, the "A" could be replaced by a
cell reference which contains the letter you are interested in. Both
of these are case-insensitive.

Hope this helps.

Pete

On Oct 2, 12:31 pm, 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- Hide quoted text -

- Show quoted text -