Hey again,

Is there a formula I can use to figure out if there is one specific phrase
in a selection?

I'm updating the attendance prgram at the school that I work at. Every
student has their own attendance sheet in Excel, and each sheet sort of looks
like this:

|Monday|
Period 1:| A | (A=Absent; S=Seat time)
Period 2:| S |
Period 3:| A |

So basically, if they have one or more "S"s, we can count them as being
present for the day. I need the formula to find out if there is an "S" in
that column, and if there is, I need it to type an "S" in the attendance
report, which sort of looks like this:
DATE: |1|2|3|
Student Name |S| | |

Sorry if that got a little complicated. Is there any way to do this?