Splitting cells
Select the column of data and then click DATA in the menu, select TEXT TO
COLUMNS.
You'll want to make sure that there are enough blank columns to the right of
the source data to accommodate the parsed data.
--
Kevin Backmann
"Splitting one cell into multiple cells" wrote:
Is there a way in Excel to split a cell into multiple cells?
|