I have a list of words in Excel, many of them with suffixes. I have a list of 170 suffixes that I want to remove from these words. I only want to remove a suffix once, starting with the longest suffix.
So, I just need a macro to do this.
Read cell X.
See the chars in cell X end with any of the suffixes in the list of 170 (starting with the longest ones).
If a match is found, truncate the string in cell X to remove the suffix, and write to word root a new column.
There also is one additional, minor macro I need help with. Should be a breeze for someone who knows Excel macros well.