|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
how to count occurences of word in spreadsheet formula
"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.
Agreed.
Rick
|