oops, just noticed, some of them have a dash - at the end, what does that
signify?

--

HTH

RP

"Dan B" wrote in message
...
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!!