> "Myrna Larson" <myrnalar...@charter.net> wrote in message
> news:h92rivc2onutmepsmd2s2cecms0ri31o79@4ax.com...
> > A blank cell and one containing a zero-length text string are not the same
>  thing. The latter
> > isn't blank. It contains text, even though you don't see anything.

> > On Sun, 3 Aug 2003 13:57:49 -0700, "Da Moose" <shaza...@hotmail.com>
>  wrote:

> > >Ok.. thanks for the help.

> > >One thing that still surprises me is that when I paste
> > >special - values a group of cells that my initial formula
> > >has deemed "", Excel still does not see them as blank.

> > >>-----Original Message-----
> > >>You can't.  A cell with a formula is automatically not
>  Blank.

> > >>In a worksheet function  you can test with something like
> > >>   =IF(TRIM(A1)="",True,False)
> > >>or if you want to make sure the length is zero
> > >>   =IF(LEN(A1)=0, True, False)

> > >>You can use the VBA functions of the same name in a macro
> > >>to test individual cells before deciding what you want
>  to do.

> > >> You could make a copy of the worksheet and then test
>  with
> > >>TRIM to wipe out anything that looks empty.
> > >>---
> > >>HTH,
> > >>David McRitchie, Microsoft MVP - Excel    [site changed
>  Nov. 2001]
> > >>My Excel Pages:
>  http://www.mvps.org/dmcritchie/excel/excel.htm
> > >>Search Page:
>  http://www.mvps.org/dmcritchie/excel/search.htm

> > >>"DaMoose" <shaza...@hotmail.com> wrote in message
>  news:00c401c359fb$f1a82da0$a601280a@phx.gbl...
> > >>> I have some forumulas that say if a reference cell is
>  not
> > >>> equal to a certain number,  then "", otherwise do
> > >>> something else.  Well, when I copy these cells (the
>  cells
> > >>> that are "") and paste special values (using the skip
> > >>> blanks option), the paste result does not skip these
> > >>> cells because it does not consider them "blank".  What
> > >>> can I do to make these cells qualify as "blank" in the
> > >>> world of Excel, while still keeping my formula in that
> > >>> cell?

> > >>> Thanks

> > >>.