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

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 <jaedong1...@gmail.com> 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

Hi,

Can you please verify these links.
http://www.lytebyte.com/2008/02/28/h...-office-excel/
http://www.digdb.com/excel_add_ins/d...olumns_sheets/

I hope this will help you.
--
Anuma Reddy
http://www.GGKtech.com



"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
>
>

Try select column A and F5>Special>Blanks>OK

Edit>Delete>Entire Row

Record a macro whilst doing.


Gord Dibben MS Excel MVP

On Tue, 21 Oct 2008 23:57:06 -0700 (PDT), James8309 <(E-Mail Removed)>
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

On Oct 23, 4:51*am, Gord Dibben <gorddibbATshawDOTca> wrote:
> Try select column A and F5>Special>Blanks>OK
>
> Edit>Delete>Entire Row
>
> Record a macro whilst doing.
>
> Gord Dibben *MS Excel MVP
>
> On Tue, 21 Oct 2008 23:57:06 -0700 (PDT), James8309 <jaedong1...@gmail.com>
> 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- Hide quoted text -
>
> - Show quoted text -

When I do this;

Try select column A and F5>Special>Blanks>OK

Edit>Delete>Entire Row


It says "Selection is too large"

Is that the complete message?

I assumed Excel 2007 would be similar to Excel 2003 and earlier.

I guess with a "few hiundred thousand rows" Excel gets over-taxed?

I don't use 2007 so cannot test.


Gord

On Wed, 22 Oct 2008 15:28:24 -0700 (PDT), James8309 <(E-Mail Removed)>
wrote:

>When I do this;
>
>Try select column A and F5>Special>Blanks>OK
>
>Edit>Delete>Entire Row
>
>
>It says "Selection is too large"