Hello; I know this is discussed in many places, but I am just having a tough time wrapping my head around all that is involved, I am posting a real sample of the data I am trying to split.
Using Excel 2013
What I am looking to do is:
Cell I4 contains "Mashed Potato, Corn Bread, Steamed Carrot, Garlic Bread"
Need to use formula to split this into 4 separate column cell (Comma Delimited) I5, I6, I7, I8
If there are only 3 in the Delimited text, then the forth column cell (I8) would remain blank.
The Delimited text could be anywhere from 1 - 4 items
If I4 only has a single item, then no comma would exist and value would go to I5.
If I4 has 2 items then I5 & I6 would contain the 2 (I7 & I8 would be left blank)
and so on.
Thank you
Elso
Bookmarks