I am trying to parse a very large text document in excel using text to
column. There are about 3000 lines that need to be parsed, but every 15
lines or so there is a break so I have to do each group seperately. Once I
reach line 300 or so, when I use text to column, it does not auto place the
separating lines and I have to insert each line maually. Is there a way to
make it auto insert the lines through the entire document?

Thanks

Select a column and F5SpecialBlanksOK

EditDeleteEntire Row

That should get rid of the blank rows.

Separating lines in the text to columns dialog are dependent upon what you
are using as de-limiter.

Or if using "fixed width" you may have to click to enter separator lines.


Gord Dibben MS Excel MVP

On Thu, 18 Jun 2009 13:30:02 -0700, Erin
wrote:

I am trying to parse a very large text document in excel using text to
column. There are about 3000 lines that need to be parsed, but every 15
lines or so there is a break so I have to do each group seperately. Once I
reach line 300 or so, when I use text to column, it does not auto place the
separating lines and I have to insert each line maually. Is there a way to
make it auto insert the lines through the entire document?

Thanks