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