Hi
Search this group using "How do I delete empty rows?" and there are
probably dozens of solutions.
regards
Paul

On Oct 22, 7:57*am, James8309 wrote:
Hi everyone,

I have about 100 text files containing large amount of data.

when I paste it into excel 2007 it is like below;

Column A

DATA~~~~~~~

BLANK ROWWWWWWWWW

DATA~~~~~~~~~~

BLANK ROWWWWWWWWW
.
.
.
.

it goes on and on upto about few hundred thousand rows.

How do I use fast and effective macro to delete empty rows entirely in
column A:A?

Thank you for your help in advance.

Regards,

James