Harlan Grove wrote:
Aladin Akyurek wrote...

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

...

And that requires?

I wasn't proposing (put otherwise: intended to propose) de-punctuation
of the target string by means of formulas using Excel's current functions.

[...]


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


Quite so.