Split delimeted text to columns Excel 2013

Yes, I see how that could have sounded confusing.
This site seemed to have been down for a short bit so I did post my question on 2 other sites as well, only to learn about a cross post rule.
For the record the 2 other site posts:
excelguru can't post the URL

and here: ozgrid can't post the URL

I should have said "break text to cells"

I just uploaded a file name "text split test.xlsx" but I don't see where it went when uploaded using the manage attachments link below.
but here is a link to my upload: can't post the URL


This is a very small piece to a rather large work book project.
I am a chef in a retirement community and the object here is to collect and tally the resident meal choices.
This piece of the puzzle, each resident populates a single row.
Each resident had a data validation list of the 3 or 4 side dished for the given meal.
Using some VBA allows this data validation to be a multi select dropdown and populated the cell with a delimited test string like in my sample.
The next step in the project is to count how many mash potatoes, steamed carrots, corn bread...etc.
I could count all instances in the column using wild cards, this would work unless
the side choices included "corn" & "corn bread" This would give an inaccurate count for the corn.
I am now thinking that the easiest error free method would be add 4 helper cells that the selections can get split to, then I retrieve my counts using absolute criteria.
In the end, these 4 helper cells/columns would be hidden.

Thank you for trying to understand what I'm looking for.

Elso