Parse Text
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
|