Is there a way in Excel to split a cell into multiple cells?
S Splitting one cell into multiple cells Sep 19, 2007 #1 Is there a way in Excel to split a cell into multiple cells?
P Peo Sjoblom Sep 19, 2007 #2 You can "split" contents using data>text to columns -- Regards, Peo Sjoblom "Splitting one cell into multiple cells" <Splitting one cell into multiple [email protected]> wrote in message news:[email protected]...
You can "split" contents using data>text to columns -- Regards, Peo Sjoblom "Splitting one cell into multiple cells" <Splitting one cell into multiple [email protected]> wrote in message news:[email protected]...
K Kevin B Sep 19, 2007 #3 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.
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.
R Ron Rosenfeld Sep 19, 2007 #4 Is there a way in Excel to split a cell into multiple cells? Click to expand... Yes there is. The applicable method depends on details you have not chosen to provide, however. --ron
Is there a way in Excel to split a cell into multiple cells? Click to expand... Yes there is. The applicable method depends on details you have not chosen to provide, however. --ron
