[Rozman]

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

[Bernard Liengme[_2_]]

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" wrote in message
...
How can i break apart a comma delimited text string in a single cell to
multiple cells based on comma loaction?

[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