seperate data from one cell into multiple

[flow23]

I have to import data in CSV format.
one of the fields/ column contains data is as following :Christmas toy(Card
B) * 1, Night out(Card A) * 1

basically product * quanty and then a comma and then next product and so on.
what I want to do is separate each product into different field / column.
the max number of products it can have in one column is 12.

any help appreciated

 

[Dave F]

Data--Text to columns.

Use comma as your text delimiter.

Dave