Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter - Blank vs Space
I was suprised to see that a Blank is treated identical to a cell containing
a single space. I needed this in order to preserve section formatting while filtering the entire sheet. I'm not suprised however, as the Filter feature probably includes a built in trim function. Ha!, not good though if dealing with a single space, really, come on. The workaround is to use a different character like a period. However, it forces me to change the font color to match the background color of the cell. This workaround is tedious since there are two background colors to deal with. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why does blank space appear at end of number? | Excel Discussion (Misc queries) | |||
add blank space in cell if first name is not blank | Excel Worksheet Functions | |||
is there a limit to the amount of space in filter | Excel Discussion (Misc queries) | |||
BLANK SPACE TO A NUMBER | Excel Worksheet Functions | |||
I want a blank space on a worksheet when the question is blank? | Excel Discussion (Misc queries) |