In column B1 enter the formula =A2
Highlight B1 and B2
Double click on the fill box (the little black box on the lower right side of the cell) this will fill column B with the addresses.
It should look like this
Highlight column B.
Copy the column (Ctrl+C)
Right click on column B header and choose Paste Special... Choose values
Press F5, click on the Special button - choose Blanks
Press Ctrl +"-" (minus) or right click one of the highlighted cells and choose Delete
Choose entire row.
It's easier than it sounds - I'll post a macro soon
Bookmarks