I need to see if a particular letter appears

S

Sherry

I have a large file and need to know if the letter Y appears anywhere in
Column A - each cell is about 25 characters. Y might be in position 1,
position 25 or anywhere in between. How can I do this?

Help me, gurus!
 
S

Sherry

Just found a way.

=IF(ISNUMBER(FIND("Y",L3)),1, "")

If there's a Y in L3 it puts a one in this cell and leaves it blank
ifthere's no Y.
 
Top