Distinguishing blank cells

  • Thread starter Thread starter daniel chen
  • Start date Start date
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?
 
Hi David,

=Isblank(A1)

returns true if A1 an empty cell and false in the other cases you indicate.
 
Hi Norman, Thank you.
Is there a blanket operation similar to "Formula Auditing" to look into?
 
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.
 
Hi Daniel,

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

Sorry agan!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Having Blank Cells, etc. ? 1
Leaving a formula cell blank when data has not yet been added. 5
Sorting blank cells with a formula in them 1
Copy/Paste cell down to next value- Easy question, can't figure it 2
Excel 2002: Any button to insert blank rows at specific interval? 5
Blank cell not really blank 10

Back
Top