seperate data from one cell into multiple
 

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

seperate data from one cell into multiple
 

Data--Text to columns.

Use comma as your text delimiter.

Dave
--
Brevity is the soul of wit.


"flow23" wrote:

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