Selecting Rows
 

Hi,
I'm importing into XL data from an MS-DOS application, I really don't
know what type it is. I have to delete lots of bits and pieces which are
different on each download so it has to be done manually.
When I'm done, I end up with the data I want, but with a row beneath
each meaningful row that is not empty, but of no use to me, and I want to
delete all these rows. There can be up to 1500 or more rows and deleting
every other row by hand is very tedious.
Could anyone please explain how to SELECT every other row, either odd or
even so I can delete them? I don't want to delete automatically as I want to
check it first,
TIA,
Regards,
Alan.

Selecting Rows
 

Alan,

Don't know if this will help but if there is a column in your "useless" rows
that is blank, and cells in the "good" rows always have something you can do
this:

Select this column.
GoTo Special Blanks
Delete Entire rows

You can record this and build a macro.

If there is an identifiable 'string' in these rows that is not in the other
rows,
you can precede the above with a Replace 'string' With
(don't put anything in the with box).

This is a fast approach to delete blank rows.
Other wise you have to build a loop and start from the bottom.
(this is the slow way)

--
sb
"Alan" wrote in message
...
Hi,
I'm importing into XL data from an MS-DOS application, I really don't
know what type it is. I have to delete lots of bits and pieces which are
different on each download so it has to be done manually.
When I'm done, I end up with the data I want, but with a row beneath
each meaningful row that is not empty, but of no use to me, and I want to
delete all these rows. There can be up to 1500 or more rows and deleting
every other row by hand is very tedious.
Could anyone please explain how to SELECT every other row, either odd
or
even so I can delete them? I don't want to delete automatically as I want
to
check it first,
TIA,
Regards,
Alan.

Selecting Rows
 

Steve,
Thank you so much, too much thought, wood and trees etc on my part,
Thanks Again,
Alan.
"steve" wrote in message
...
Alan,

Don't know if this will help but if there is a column in your "useless"
rows
that is blank, and cells in the "good" rows always have something you can
do
this:

Select this column.
GoTo Special Blanks
Delete Entire rows

You can record this and build a macro.

If there is an identifiable 'string' in these rows that is not in the
other
rows,
you can precede the above with a Replace 'string' With
(don't put anything in the with box).

This is a fast approach to delete blank rows.
Other wise you have to build a loop and start from the bottom.
(this is the slow way)

--
sb
"Alan" wrote in message
...
Hi,
I'm importing into XL data from an MS-DOS application, I really
don't
know what type it is. I have to delete lots of bits and pieces which are
different on each download so it has to be done manually.
When I'm done, I end up with the data I want, but with a row beneath
each meaningful row that is not empty, but of no use to me, and I want
to
delete all these rows. There can be up to 1500 or more rows and deleting
every other row by hand is very tedious.
Could anyone please explain how to SELECT every other row, either
odd
or
even so I can delete them? I don't want to delete automatically as I
want
to
check it first,
TIA,
Regards,
Alan.

Selecting Rows
 

Alan,

Sounds like it works!!! Glad it was a 'simpler' solution...

Excel can do that to you...

And - You're very welcome!!!

--
sb
"Alan" wrote in message
...
Steve,
Thank you so much, too much thought, wood and trees etc on my
part,
Thanks Again,
Alan.
"steve" wrote in message
...
Alan,

Don't know if this will help but if there is a column in your "useless"
rows
that is blank, and cells in the "good" rows always have something you
can
do
this:

Select this column.
GoTo Special Blanks
Delete Entire rows

You can record this and build a macro.

If there is an identifiable 'string' in these rows that is not in the
other
rows,
you can precede the above with a Replace 'string' With
(don't put anything in the with box).

This is a fast approach to delete blank rows.
Other wise you have to build a loop and start from the bottom.
(this is the slow way)

--
sb
"Alan" wrote in message
...
Hi,
I'm importing into XL data from an MS-DOS application, I really
don't
know what type it is. I have to delete lots of bits and pieces which
are
different on each download so it has to be done manually.
When I'm done, I end up with the data I want, but with a row
beneath
each meaningful row that is not empty, but of no use to me, and I want
to
delete all these rows. There can be up to 1500 or more rows and
deleting
every other row by hand is very tedious.
Could anyone please explain how to SELECT every other row, either
odd
or
even so I can delete them? I don't want to delete automatically as I
want
to
check it first,
TIA,
Regards,
Alan.

Selecting Rows
 

Excel can do that to you.....

Indeed it can. And not for the first time!

Alan.
"steve" wrote in message
...
Alan,

Sounds like it works!!! Glad it was a 'simpler' solution...

Excel can do that to you...

And - You're very welcome!!!

--
sb
"Alan" wrote in message
...
Steve,
Thank you so much, too much thought, wood and trees etc on my
part,
Thanks Again,
Alan.
"steve" wrote in message
...
Alan,

Don't know if this will help but if there is a column in your
"useless"
rows
that is blank, and cells in the "good" rows always have something you
can
do
this:

Select this column.
GoTo Special Blanks
Delete Entire rows

You can record this and build a macro.

If there is an identifiable 'string' in these rows that is not in the
other
rows,
you can precede the above with a Replace 'string' With
(don't put anything in the with box).

This is a fast approach to delete blank rows.
Other wise you have to build a loop and start from the bottom.
(this is the slow way)

--
sb
"Alan" wrote in message
...
Hi,
I'm importing into XL data from an MS-DOS application, I really
don't
know what type it is. I have to delete lots of bits and pieces which
are
different on each download so it has to be done manually.
When I'm done, I end up with the data I want, but with a row
beneath
each meaningful row that is not empty, but of no use to me, and I
want
to
delete all these rows. There can be up to 1500 or more rows and
deleting
every other row by hand is very tedious.
Could anyone please explain how to SELECT every other row,
either
odd
or
even so I can delete them? I don't want to delete automatically as I
want
to
check it first,
TIA,
Regards,
Alan.