eliminating blanks

I am looking for the following formula: eliminating blank cells from a list containing both data and blanks.

Thanks.

You could either write a macro to find the blanks in the list and delete them, or manually you could sort the list, thus grouping all the blanks together for deleting. Or if you are trying to get rid of the spaces (created by users who use the space bar to 'empty' out cells). use a find and replace where the cell contains a space, and the entire cell is a match.

Simon shaw

"geza" wrote:

I am looking for the following formula: eliminating blank cells from a list containing both data and blanks.

Thanks.

Thanks Simon,

geza.

"Simon Shaw" wrote:

You could either write a macro to find the blanks in the list and delete them, or manually you could sort the list, thus grouping all the blanks together for deleting. Or if you are trying to get rid of the spaces (created by users who use the space bar to 'empty' out cells). use a find and replace where the cell contains a space, and the entire cell is a match.

Simon shaw

"geza" wrote:

I am looking for the following formula: eliminating blank cells from a list containing both data and blanks.

Thanks.

EditGo ToSpecialBlanksOK

EditDelete

Gord Dibben Excel MVP

On Tue, 15 Jun 2004 11:56:01 -0700, "geza"
wrote:

I am looking for the following formula: eliminating blank cells from a list containing both data and blanks.

Thanks.

couldnt you just use the trim function ??? .

or just hit cntrl h and replace a space with nothing ? .... of course
that assumes that there are no spaces in the stuff you actually want


but i really dont see why you couldnt use the trim function


---
Message posted from http://www.ExcelForum.com/

foolio

TRIM Function eliminates extra spaces from cell data, it does not delete blank
cells as OP desired.

Gord

On Wed, 16 Jun 2004 18:42:36 -0500, foolio
wrote:

couldnt you just use the trim function ??? .

or just hit cntrl h and replace a space with nothing ? .... of course
that assumes that there are no spaces in the stuff you actually want


but i really dont see why you couldnt use the trim function


---
Message posted from http://www.ExcelForum.com/