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


"edellav" wrote in message
...
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.