| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting alternate blank rows in Excel | Excel Discussion (Misc queries) | |||
| is there a way to delete alternate rows in excel | Excel Discussion (Misc queries) | |||
| How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
| How to quickly insert a blank row every 5 rows? | Excel Discussion (Misc queries) | |||
| HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) | |||
Linear Mode
