seperate data from one cell into multiple

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining same data in multiple rows 4
How do I consolidate data from several spreadsheets into one. 4
Seperating numbers from text 2
Excel worksheet moved all data from multipl cells into one 1
VBA Excel partial cell compare to another cell 0
Exctracting comma seperated data from a single cell 3
Open CSV In One Column or Multiple Columns? 2
Data Validation - Multiple Dependent Lists 4

Top