Find first character in cell
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
|