Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter a blank, not "", into a cell with a conditional for
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter a blank, not "", into a cell with a conditional for
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 "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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter a blank, not "", into a cell with a conditional for
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
blank cell turns to 0 | New Users to Excel | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
conditional formatting blank cell | Excel Discussion (Misc queries) |