No Problem.
One might not fully understand the question [ happens to me twice a day ;-)
] but in such cases - if somebody presents a different solution, than mine, -
I always bother to check it out and in most cases the those differences
"lighten" my eyes and help to better understand the question.
Micky


"pmartglass" wrote:

thank you for correcting me


"מיכאל (מיקי) אבידן" 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!