View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DaveyC4S DaveyC4S is offline
external usenet poster
 
Posts: 7
Default Creating a separate cell entry for every individual line in a cell

Hi

I have a lot of cells of data with free text in them.

In order to use this data I need to create a separate cell for every line of
text within a cell.

The lines have been defined in the original cells using the Alt-Enter
function.

Does anyone have an idea of how to tackle this?

Any help much appreciated
David