How do I enter a blank, not "", into a cell with a conditional for

[Guest]

Sort sequence rules place blank cells at the end of both ascending and
descending sorts which is what I want. However, cells that contain "" are
sorted before numbers in descending sorts, which I don't want. I create a
conditional formula to test for division by a cell that is blank, if true, I
want the result to be a true blank cell, not a cell with "". Is there a
special character code or function that I can use to accomplish this? I'm
using Excel 2002.

 

[Arvi Laanemets]

Hi

No, there isn't. The only way to create a really blank cell is to delete the
entry from it - i.e. the formula (manually or through VBA procedure). But
when after that you change data in your workbook, there will be no formula
to reflect new answer anymore.

So better think, how to cope with "" as result.

Arvi Laanemets

 

[macropod]

Hi edellav,

There isn't a function to input a 'blank' into a cell - the nearest you'll
get is a "". However, for sorting purposes, you could modify your formula to
output CHAR(160) instead of "". Since ASCII 160 (which is what CHAR(160)
produces), falls after the standard alpha-numeric characters, the cells
containing it will be sorted after the others (in an ascending-order sort).

Cheers