Thread: Splitting cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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?