View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sunil Ahuja Sunil Ahuja is offline
external usenet poster
 
Posts: 1
Default Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells

Hello,

I have a lot of columns and a lot of rows in 1 spreadsheet. In one of
the columns, there are a lot of cells within that column which contain
multiple pieces of data separated by "ALT-ENTER" within each cell.
Does anyone know how to split out the content within these cell into
multiple rows/cells (again, the content is currently separated by "ALT-
ENTER")?

Thanks!