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