With a little workaround:
Suppose your range ia A1:A10.
a) Select the whole range press [F5] 'Special...' mark 'constants' OK
b) Press CTRL+C (for copy) select cell B1 press CTRL+V.
c) Delete column "A"
C'est tout
Micky


"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!