pmartglass does not understand the "skip blanks" function.

Skip Blanks is to prevent overwrite existing data in the paste area.

Blank cells are still pasted as you have seen Micky.


Gord Dibben MS Excel MVP

On Fri, 5 Mar 2010 10:22:01 -0800, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

One of our "Excel" software is faulty.
I checked your suggestion 2-3 times (in Excel 2003) before replying.
Maybe 2-3 DC members will be kind enough to check it out...
Micky


"pmartglass" wrote:

no, buy selecting the skip blank cells it repastes without the blank cells -
thus condensing the information

"????? (????) ?????" wrote:

Wouldn't this leave him with the SAME layout - meaning with all the previous
empty cells ?!
Micky


"pmartglass" wrote:

select the column
right click
copy
right click
paste special
select skip blanks

hope this helps

"ILunacy" wrote:

I have a column with about 500 addresses. There is a blank cell in between
each address. Is there any way to remove all the blank cells at once WITHOUT
sorting the addresses? The addresses aren't in any alphabetical or numerical
order, and I have to keep them in the order they are currently in, So I can't
use the sort function.

Thanks!