Quote Originally Posted by woody80uk View Post
I have uploaded without open office and it seems fine (Now I have read the instructions on what to do) :) Ive just used Excel 2003 saved as comma delimited csv.
If you are converting your category columns from EP 1.2.5.4, you can simply add a new column, then use the concatenate function in excel.

Something like this: =concatenate(A34,"^",B34,"^",C34,"^",D34,"^",E34)

Now insert a new column named v_categories_1 and copy the concatenated column, but paste-special and select "values". This will paste the character data.

Now you will combine all your combined categories, but will also give you some doubled ^^ (or more) for the empty column entries. Hilight your v_categories_1 column and do a search for ^^ and replace with ^. I haven't done this for a while, but you may also have to trim the last column.

Now, better than doing the above.... Install EP4 on your old store (you can have both versions installed without issue) and do your export with EP4 and all the problems you are having are pretty much solved

-chadd