I'm looking for a formula that would remove the last character of a word if it is an "s".

There can be multiple words and instances of "s" in a cell. Therefore, it needs to check the end of every word in the cell and remove the s from any that end in s.

So basically making plural to singular, perhaps multiple times in a cell.

Anyone's help is appreciated!