software

I have a table of data and i want to delete a block of blank cells within it.

i.e. A b c d e f g h i
1 x x x x x x x x x
2 x x x x x x x x x
3 x x x...................x
4 x x.......[blank]...x
5 x x...................x
6 x x x x x x x x x
7 x x x x x x x x x

Does anyone know a marco that could select these cells and delete them and the data in column i move to column d. Note there may be some cells that are blank i.e. a5 amp; b4 that i do not want to delete.

Appreciate any support.
Record a macro when you select your range (avoid columns A:B???)
then edit|goto|special|Blanks
edit|delete|shift cells to the left
stop recording

And you'll have your code.

GarToms wrote:
gt;
gt; I have a table of data and i want to delete a block of blank cells
gt; within it.
gt;
gt; i.e.
gt; A b c d e f g h i
gt; 1 x x x x x x x x x
gt; 2 x x x x x x x x x
gt; 3 x x x...................x
gt; 4 x x.......[blank]...x
gt; 5 x x...................x
gt; 6 x x x x x x x x x
gt; 7 x x x x x x x x x
gt;
gt; Does anyone know a marco that could select these cells and delete them
gt; and the data in column i move to column d. Note there may be some cells
gt; that are blank i.e. a5 amp; b4 that i do not want to delete.
gt;
gt; Appreciate any support.
gt;
gt; --
gt; GarToms

--

Dave Peterson