F
Frank Pytel
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
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