Parse Text

[Erin]

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

 

[Gord Dibben]

Select a column and F5>Special>Blanks>OK

Edit>Delete>Entire 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