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

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Rozman" <(E-Mail Removed)> wrote in message
news:9FEF33ED-3C0C-4C84-8400-(E-Mail Removed)...
> How can i break apart a comma delimited text string in a single cell to
> multiple cells based on comma loaction?

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