Hi Everyone,

I receive a large spread sheet weekly, one or the column contains comma separated values, I need to separate those values 1 per cell.

Maximum CSV is 5; I would need to get the output to 5 cells next to them,

Example,

Source data
(A1) 10,11,12,13,14

Output needed
(B1) 10
(C1) 11
(D1) 12
(E1) 13
(F1) 14

I have no clue where to start, any help you could provide would be greatly appreciated

bigtonyicu,

Highlight all the cells in column A.

Then click on Data, Text to columns, radio button "Delimited", click on the next button, click for "comma", and click on the "Finish" button.


Have a great day,
Stan

stanleydgromjr

Windows Vista Business and Excel 2003, 2007.

Thank you very much!!!