Delete all blank rows...
 

I have a spreadsheet with over 46,000 rows. around half are blank. I need to
remove all these blank rows, so I can add about 30,000 more. The problem is
this....the rows are not really blank. They have expressions in those cells
that, when calculated, solve to "". The length of the string is 0, but there
is still an expression there, so I am assuming that is why none of my
functions/vba have worked so far. Any ideas? I don't care if the solution
is DeleteAllEmptyCells or DeleteEmptyRows, or whatever. I'm stuck. Thanks
for the help.

Delete all blank rows...
 

Try adding another column which counts blanks (e.g. =COUNTBLANK(A2:G2)
in column H). Then apply DataFilterAutoFilter selecting the largest
value in the list and delete all rows.

Delete all blank rows...
 

Can you pick out a column that always has data--except for those cells with rows
that should be deleted?

If yes, you could sort by that column to group those "blank" rows and delete
them in one time.

Be aware that if you have really empty cells, they'll be at the bottom.

bourbon84 wrote:

I have a spreadsheet with over 46,000 rows. around half are blank. I need to
remove all these blank rows, so I can add about 30,000 more. The problem is
this....the rows are not really blank. They have expressions in those cells
that, when calculated, solve to "". The length of the string is 0, but there
is still an expression there, so I am assuming that is why none of my
functions/vba have worked so far. Any ideas? I don't care if the solution
is DeleteAllEmptyCells or DeleteEmptyRows, or whatever. I'm stuck. Thanks
for the help.

--

Dave Peterson