Bob,
Here is the spreadsheet from the other post. I just copied a piece of the
data into this one. You'll be able to see what I was trying to
accomplish.....splitting data in column A into 3 separate columns. Column B
worked fine. In column C, I wanted the words, but only got part of them.
Column D is your formula.

Thanks for your help!!