I've got a cell with some text in it.

Example - A1 has the text "This is a test"

I'm trying to come up with a formula that will tell me the location of the
last "s" in this cell. I've tried using a FIND function, but that will only
give me the first occurrence starting at whatever position I specify. How
can I get the location of the last "s" without knowing a starting position?

Thanks,
Paul