Extract each item in the list by function

[0-0 Wai Wai ^-^]

Hi.
The cell A1 contains:
Here's the shopping list: pig, dog, hamburger, chocolate..., beef. Please
purchase all of them. Thanks!

I would like to extract each item separately to different cells, ie
B1:
=Display1stItem
B2:
=Display2ndItem
....
B?:
=DisplayLastItem + CropText ". Please purchase all of them. Thanks!"

How to do?

 

[0-0 Wai Wai ^-^]

Forget to say.
There are different contents with different item list.
Plus the wording of the contents and items are subject to change.
So something like: MID(A1, 24, 5) is not preferred.

Probably they can figure out which word to extract by pattern.
In my case, when the list starts, it must start with colon ).
For each item, comma (,) is used to separate each of them.

So it would be if a function manages to work like the following:
.... ...: pig, cow, button. ...

.... Read ). the extracting starts -->
Read pig --> Read (,) --> the item is extracted.
Read cow --> Read (,) --> the item is extracted.
Read button --> Read (.) --> the item is extracted, and stop reading after that
fullstop(.)

 

[Arvi Laanemets]

Hi

Text-To-Columns feature (you can find it from Data menu) with comma and
colon as delimiters will do. (You must have enough empty columns to right of
the one with entries). As result, you get all entries separated into
columns - the text to left of colon remains unmoved, the 1st item in next
column, etc.

 

[0-0 Wai Wai ^-^]

Note:
I have moved my question to "microsoft.public.excel.worksheet.functions"