I need to see if a particular letter appears

  • Thread starter Thread starter Sherry
  • Start date Start date
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!
 
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.
 
Back
Top