Re: Distinguishing blank cells

From: Norman Jones (normanjones_at_whereforartthou.com)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 01:26:34 +0100

Hi Daniel,

Apologies. Despite your clear signature, I called you David.

Sorry agan! 

---
Regards,
Norman
"daniel chen" <danchen@worldnet.att.net> wrote in message
news:i5xUc.467863$Gx4.106687@bgtnsc04-news.ops.worldnet.att.net...
> Hi Norman, Thank you.
> Is there a blanket operation similar to "Formula Auditing" to look into?
>
> "Norman Jones" <normanjones@whereforartthou.com> wrote in message
> news:e7ssQ%23KhEHA.2908@TK2MSFTNGP10.phx.gbl...
> > Hi David,
> >
> >         =Isblank(A1)
> >
> >  returns true if A1 an empty cell and false in the other cases you
> indicate.
> >
> > ---
> > Regards,
> > Norman
> >
> >
> >
> > "daniel chen" <danchen@worldnet.att.net> wrote in message
> > news:zRvUc.219162$OB3.38054@bgtnsc05-news.ops.worldnet.att.net...
> > > There are 3 kinds of blanks.
> > > I don't known what you call them.  Let's say
> > > 1)   a string blank :  derived  from    = '
> > > 2)   an embedded blank :  derived from    = ""   either by assignment
or
> > by
> > > conditional formula.
> > >            When this was copied, and paste-special-value-only, it
turned
> > > pseudo empty
> > > 3)   an empty blank :  a true virgin blank
> > >
> > > Is there a way to distinguish the embedded blanks from the empty
blanks
> in
> > a
> > > work***?
> > > Any idea?
> > >
> > >
> >
> >
>
>