Good Morning;

I am trying to parse the contents of a cell to new columns. There may be
numbers but I am not worried about that. I would like to parse the entire
string to new cells in the same row. The strings can be up to 20 words. I can
paste the functions down the row and adjust them as needed. A macro would be
ok, but once parsed I need to Concatenate them back to what I need and my
needs will be extremely random.

All values will be separated by spaces which is nice. I have gotten as far
as the first space but can't seem to tell it to find the second, third etc.
spaces.

String Example

Aveeno Baby Body Wash - Soothing Relief Creamy

First word =LEFT(B1,FIND(" ",B1)-1) "Aveeno" Works fine.
Second word =MID(B1,FIND(" ",B1)+1,FIND(" ",B1)) "Baby Bo" I would like to
find that second space.
Last Word =RIGHT(B1,FIND(" ",B1)-1) "Creamy" Right is kind of flaky. Is
there a better way to do this. I am checking my data set for odd characters
and have found them. Fortunately I can globally change them to space with the
find/replace dialog.

From there I am stuck. I can't figure out how to increment through the
spaces to find the 2nd and 3rd, 3rd and 4th etc. spaces.

I would sincerely appreciate any help you would be able to offer.

Have a Blessed Day.

Frank Pytel