You're welcome & thanks for the feedback

It's simply 6StringJazzer's formula with a SUBSTITUTE function added.
I'm guessing that you copied the data from a web page, or some other outside source, and rather than having "normal" spaces it had "non breaking" spaces.
The SUBSTITUTE "swaps" one for the other.