"Rick Rothstein \(MVP -
VB\)" wrote...
That would miss something like...
"Rover (my dog) is my best friend."
The problem in trying to isolate words, as whole words, is being
able to enumerate all of the possible delimiters for them.
....
Which is why Excel formulas, unadorned
VB[A] and similar languages
that provide only brute force, single character at a time text parsing
features are very poor tools for text processing. Regular expressions,
OTOH, are made for this.