Aladin Akyurek wrote...
For this to work, the sentence in B2 must be "de-punctuated".
....

And that requires? The OP showed HTML-like tags, so in addition to the
usual English language punctuation characters,

.. , ; : - ! ? ( ) [ ] '

you'd need to add < and . That doesn't include &, " or /, all of which
appear from time to time in prose, and * and _, which appear in
newsgroup postings to add emphasis (possibly irrelevant). Anyway,
that's 14 punctuation characters that'd need to be replaced by spaces.
Not possible with built-in functions even with MOREFUNC.XLL since it'd
require at least 14 nested function calls.

I'll repeat: the *ONLY* practical approach to doing this (text
processing, not number crunching) is using a udf wrapper around
VBScript regular expressions.