Nov 15 2019 04:26 PM
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. When I search on "*s," for example, I get all words that have an s in them with a letter or letters before the s, such as "finished." Is there a way to indicate in the search field that "s" or "ed" should be the last letters? Thanks for your help.
Nov 15 2019 04:54 PM
Nov 16 2019 04:41 PM
@MHJ_52It's not altogether clear what you mean by "large Excel document." If you mean a large Excel spreadsheet, then the follow-up questions are:
If each cell contains only single words then the prior answer you already got will work for finding those ending in "s" or "ed"
If, on the other hand, each cell to be searched contains a sentence, so long as it only contains one verb per sentence (no subordinate clauses, etc.), then you might be able to search with something like
=IF(FIND("ed ",A3),"Look here",""), changing the "ed " to "s " for the other, although be aware that the latter will find words like "This" as well as verbs ending in "s".
Nov 16 2019 07:54 PM
@mathetes, thanks for your help and apologies for the confusing use of the word document. The words are in columns, but I will save your second answer and may well have a need for it.
Nov 16 2019 07:54 PM
@Twifoo, thanks very much indeed. This is what I needed.