Forum Discussion
Searching for verb tenses
I need to search a large Excel document for verbs in the present and past tense. I would be satisfied if I could just find all words that end in "s" or "ed," but I can't figure out how to do that. Wh...
If your search field is Column A, you may try this for “s”:
=RIGHT(A:A,1)=“s”
For “ed”, try this:
=RIGHT(A:A,2)=“ed”
Note that the foregoing must be nested within another formula, like SUMPRODUCT, the construction of which depends upon your requirements.
=RIGHT(A:A,1)=“s”
For “ed”, try this:
=RIGHT(A:A,2)=“ed”
Note that the foregoing must be nested within another formula, like SUMPRODUCT, the construction of which depends upon your requirements.
