parse cell and insert rows?
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
|