My suggestion not quite neat but you can give it a try.

Insert a column in A. This will give you blank column at the start of your
sheet
In A1 write this formula =COUNTA(B1:IV1). if your does not start in A1,
then adjust formula accordingly
Drag the formula down up to your last row (Assuming A100). Those rows
with no data will have zero (0) as a result
Select A1 to A100.
hit ctrl+c (copy)
editpaste specialvalues
hit ctrl+h (find and replace). Find what: 0, Replace with: (do not type
anything), check match entire cells (click option if you don't see it)
hit ctrl+g (go to), click special, choose blanks, click Ok
editdeleteentire row

Sorry for my wordings if it is hard to understand.


"Landa" wrote in message
...
I have an excel table which contains hundreds of rows with variable columns
(e.g. row 1 has data in 5 cells, row 2 has data in 10 cells etc). There
are
blank cells in some of the rows and they are not in a regular pattern. Is
there any way I can remove all those blank cells?

Thanks a lot in advance!