Distinguishing blank cells

D

daniel chen

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
worksheet?
Any idea?
 
N

Norman Jones

Hi David,

=Isblank(A1)

returns true if A1 an empty cell and false in the other cases you indicate.
 
D

daniel chen

Hi Norman, Thank you.
Is there a blanket operation similar to "Formula Auditing" to look into?
 
N

Norman Jones

Hi David,

Select the range of interest | hit F5 function key | Special | Blanks

This will select and highlight all empty cells in the selected range.
 
N

Norman Jones

Hi Daniel,

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

Sorry agan!
 
Top