You can break these into separate cells across a row using DataText to
ColumnsDe-limited byOtherAlt + 0010(on the numpad)


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 05:31:13 -0700, DaveyC4S
wrote:

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