Re: Distinguishing blank cells

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: daniel chen (danchen_at_worldnet.att.net)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 00:07:42 GMT

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?
> >
> >
>
>

Quantcast