What is the Null character?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the character sequence that Excel uses to represent an empty cell? I
am using a formula and when it returns false, I would like for it to
represent the cell as if it was empty. I have tried using "" as an empty
cell, but excel recognizes that this is a value, not an empty cell.
 
To pick up the original question of the excel <null> character, I am trying
to run a graph off a set of data and would like it to read <null> as a result
of the formula (so it doesnt plot the entry). If "" is used it reads this as
'0' which is not what is required. Can someone please suggest if there is any
way to return <null>?
Tks
 
How does one suggest to the Excel development team that they correct this
glaring limitation?

David C. Ziemer
 
If a cell contains a formula, how can it at the same time, appear to be
empty?
Bill Gates and crew are not magicians
best wishes
 
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

Find the first & subsequent cells to contain text in a column & re 28
Excel formula, sum the value cell and if empty cell left blank 0
Conditional Formatting Cells With Values 0 and Null 2
more character 160 leading/trailing find/replace problems 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
refer to the cell as it is empty... 2
Continuing Formula - try 3 1
Square character(s) in cells 2

Back
Top