Remove S At End Of Word To Make Singular

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!

This will do it.

=TRIM(SUBSTITUTE(A1&" ","s "," "))


Howere, there are tons of words that end with s where the s does not necessarily mean it's plural.
So you may get some s removed in error.