I recommend you upload a sample workbook with what you have AND what you want (follow the directions in the yellow banner at the top of the post).
The reason you should upload a sample workbook is because in your first post you note:

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
This indicates you want the results to be going down one column (column I).

then your second post says...

What I need this formula to do is exactly what the "Text to columns" wizard does. All items "Mashed Potato, Corn Bread, Steamed Carrot, Garlic Bread" need to remain in the same row, I just need this string broken apart so that each value goes to a separate cell in the same row.
Which contradicts the going down the column. AND if you need it to split them across the same row, why can't you use text to columns?