You can use text to columns to parse the string, then copy/paste
specialtranspose to get them into rows.



"Gorrila Grod" wrote in message
news:2004110210394316807%grod@nothankscom...
Is there a way in Excel to parse a cell that has a comma delimited
values, and put each value into rows? In this situation, the cell with
the delimited values can have a varying amount of values - and because
of formatting issues, I would like to insert new rows.

Example:

CELL A1: 10,11,12

CELL A2: 10
CELL A3: 11
CELL A4: 12

Any help would be greatly appreciated!

/grod