reformating data- how to delete alternate blank rows quickly
 

I need a quick way to delete alternate rows or blanks to reformat a mass of
data which originates as a double spaced .txt file and will end up as .mdb
file.

reformating data- how to delete alternate blank rows quickly
 

Don't know if there's a better way, but I use autofilters. Select all blank
rows a delete them


"datamanipulator" wrote:

I need a quick way to delete alternate rows or blanks to reformat a mass of
data which originates as a double spaced .txt file and will end up as .mdb
file.

reformating data- how to delete alternate blank rows quickly
 

If they are truly empty, select the lot, press F5, select special and then
Blanks, Click OK
Then do editdelete and when prompted select entire row

Before doing anything make a backup copy of your file


--


Regards,


Peo Sjoblom


"datamanipulator" wrote in
message ...
I need a quick way to delete alternate rows or blanks to reformat a mass of
data which originates as a double spaced .txt file and will end up as .mdb
file.

reformating data- how to delete alternate blank rows quickly
 

Thanks. I had found a solution using the advanced filter feature!

"Lulu Montiel" wrote:

Don't know if there's a better way, but I use autofilters. Select all blank
rows a delete them


"datamanipulator" wrote:

I need a quick way to delete alternate rows or blanks to reformat a mass of
data which originates as a double spaced .txt file and will end up as .mdb
file.

reformating data- how to delete alternate blank rows quickly
 

Thanks. I had found a way using Advanced Filter, but will remember your
method for the next time!

"Peo Sjoblom" wrote:

If they are truly empty, select the lot, press F5, select special and then
Blanks, Click OK
Then do editdelete and when prompted select entire row

Before doing anything make a backup copy of your file


--


Regards,


Peo Sjoblom


"datamanipulator" wrote in
message ...
I need a quick way to delete alternate rows or blanks to reformat a mass of
data which originates as a double spaced .txt file and will end up as .mdb
file.