How to convert Plural strings into Singular in Excel

[Autonation]

Hello friends,

i want to convert all words in a string into singular

For example:
if i have a string: " she sells sea shells on the sea shores"
i want to convert it into:
" she sell sea shell on the sea shore"

Regards
Damian

 

[JEC]

This can never be fully covered…

 

[jtakw]

Hi,

How would we know if the word is Plural versus Singular?

she sells dress on the sea shores

 

[Autonation]

i can use regexp to cover es and s ,
however i am facing a challenge if the word is horses- it changes it to a hors
i used e?s in pattern at the end of the word,

Any ideas?