csv conversion

[Rozman]

How can i break apart a comma delimited text string in a single cell to
multiple cells based on comma loaction?

 

[Bernard Liengme]

Select the column of values and use Data | Text to Columns, specify
Delimited and check the Comma box
But first make sure there are enough blank columns to the right to accept
the new values
best wishes

 

[Dave O]

Use the "text to columns" feature. First, highlight the range of CSV
data. Then, on the Excel menu, click >Data >Text to Columns. Select
the "Delimited" radio button and click Next; select the "Comma" box,
deselect the other choices, and click Next; use the Advanced Features
if you want, or click Finish.

Dave O
Eschew obfuscation