View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
datamanipulator datamanipulator is offline
external usenet poster
 
Posts: 7
Default 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.