How to remove or replace familiar words in string, by list of familiar stubs of that words, using VBA?
List contain ~30 stubs (substrings). With all of this I expect substitute hundreds matching words.
stackoverflow5.png
For this goal I use an array formula:
Formula:Please Login or Register to view this content.
But this formula have one big disadvantages: Length limitation (255 characters for values)
So Glenn Kennedy suggest to code it in VBA.
Attention! Some words contain two different stubs, and this can create conflict in substitution.
Opinion! Is better to replace/substitute, instead of delete/trim because in that way we can make correction in word, not just trimming.
Bookmarks