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?